Maybe someone can help me. I am trying to count the “yes” in my column. I did the countif function and still comes out counting all cells that have something in them. I thought maybe it isn’t recognizing the yes as a text so I changed that too. Still comes back counting everything in the cells. What am I doing wrong?

What are the chances of me getting an interview at BCG if I applied about a month ago? I’m assuming that means they likely passed on my candidacy?

Offering advice to job seekers who go around recruiters and message hiring teams, execs, etc. You are putting the Recruiters job in danger. If a Recruiter declines you or doesn’t choose to reach out, it is because the hiring team declined you, or you don’t have the experience. You will most likely not be considered for future roles because of this. When I see people giving advice to reach outside the Recruiter, it’s bad advice. Very rare is this a good idea.

Hi fishes,
I am looking for remote opportunities in SDET QA Automation. Please let me know if there are opportunities at your company!!!
YOE : 4

I lead our SOC practice for a US mid tier cpa/consulting firm. I've been losing a lot of deals due to lower cost / boutique vendors who are partnered with these SOC automation platforms (Vanta, Laika, etc.). Have any of you used these tools for the audit and what has your experience been like? Thanks

Who knows about Goosehead insurances work culture. 5 min into sourcing I’m seeing some discouraging statistics about who they move up faster vs who they don’t. I have a interview this week and I don’t know if I should even continue forward. My main goal is growth and if it’s going to be an unfair environment then that’s a no go.

Top “lifestyle” litigation firms - what are they and what are the best ones in the nyc market?

Any referrals for product development companies for 5+ years of exp in React and Next?

Hi Folks!

I am business analyst/consultant with a total work experience of 6.3 years,I am currently serving a notice period with last working day on 27th May. Let me know if you have any suitable openings in your organization.
Area of expertise: US Healthcare, Lloyd's of London P&C and RPA automations.

Looking for servicenow developer position with 3.5 years overall experience and with 2+ yrs in snow.

Just came from a salatul janazah.. 😢 😔 😞

My MOH is probably not going to be able to attend my wedding bc of covid restrictions. Freaking out slightly because I don't have someone close enough to replace her / I don't know how viable her zooming in would be? Any advice / tips?

How to deal with 3 month notice period,Nobody ready to wait for 3 month.I want to change my job please help me.
What should be the best answer I should give them.

Hi all, my aim is to join one of the faang companies after two years. I want to dedicate these two years to attain whatever knowledge ia required. My skillset is currently java, springboot thats all. What i need to prepare to get into one of these top companies. Can someone elaborate the required skillset and how many interviews and what kind of interviews and so on.

Hi and welcome to the Career Advice Bowl! Stuck on how to make your next move or what that move should even be? Had an experience you feel others could benefit from hearing about? Just need to vent for a second? We got you! Post away, all. I look forward to seeing what conversations and connections come our way.

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

How do I change line style@back to default on excel? Accidentally click on one, and now it wants to use that style every time. I just want to be able to use the ones in the typical drop down

Best websites to get more of a handle on Excel as a beginner-intermediate?

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

Still don't have xlookup. #fomo

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

What are your top Excel ninja tricks? Ones that few people know...

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap