I want to make a formula that will let me count 2 different things: count if C1:C50 is “yes” AND counta F1:F50. For some reason this was only doing the counta when I input the formula. Can someone better at this than me help 🤣 pls & ty

Hello Everyone,
Would someone be willing to refer me for a position in Salesforce at Hyderabad ? I am looking at Program Manager roles currently with 9 years of experience.

Many many thanks in advance

Hi Fishes,
Salesforce making any change to the work location flexibility once offices are re-opened? Support roles are Hyd based why other locations cannot be utilised?

Want to join Salesforce India, have 3.5 years experience as Salesforce developer what are ways I can apply?
20 days notice period remaining
Please let me know if have some reference.

Y’all done reported the partner OF post. How I’m supposed to get my juicy confessions fix if the good ones keep getting reported? SMH. 😞

Do you have a "Design System Council" or "Design Council" in your team? What kind of topics do you talk about? Just learned we have that and unclear what it's about.

When you teach a novel in class, do you assign pages for students to read at home? They never do it! How can we finish anything?

Hi, will anyone be able to share how is the work like in the equities investment team in IFC? Is it modeling intensive or more board observer role? Thanks

7/27/22 check-in. Happy hump day! What’s your workout for today?

The Bowl is oddly silent

Damn, I gained probably 10-15 pounds since traveling M-F this past month.... So fat I hate sitting down working thinking about how fat I am. I'm not even that fat but my clothes getting tight

Fti 🐠, what is the salary band for a senior director in forensic and litigation consulting?

At what point does it make sense to buy a home? I have ~700k in the stock market and a lower than average salary currently (80k) and pay 1800 a month in rent.

Anyone actually use the Networking feature here on fishbowl? Like yeah I see some of you with it on but do you actually use it besides thirsty dms?

Hadn’t noticed this sub before, and most of the threads are old so thought I’d ask a follow up - how has everyone been handling parenting with public accounting? I’ve got a toddler and my wife is an accountant (industry), and we only have a few immediate family in the country- but they have health concerns. Busy season was rough, things are looking better now as things return to normal. Still working crazy hours if you count the daycare duties on top of utilization targets.

We are hiring for senior IT auditors and cyber assessors to work on SOC2s, CMMC, pen testing, vulnerability assessments, and other similar projects. Boston area, medium/large regional firm. 2-4 years exp but flexible. Open to associates that are on the cusp of promotion to senior. Relatively low travel and better WLB compared to Big4. Feel free to DM.

Bloomberg Law or Practical Law if you had a choice?

Hi Fishes,
What will be CTC if anyone join with 10-12 years of experiance as an Automation QE. Thanks

Hi everyone, a question to the tech industry at large.

Why are people so hesitant to hire disabled candidates?

I am a visually impaired practitioner in South Africa, with 7 years of experience, and as soon as recruiters or business owners hear/read that I'm disabled, the conversation gets awkward and I never hear from them again.

I want to buy a new home and then sell my current home after we are moved out. Current home is a VA loan, is there any way to buy the second house on a VA loan?

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

Would anyone be willing to teach me vlookup?

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

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

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

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

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

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.

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?

Still don't have xlookup. #fomo