Anyone know how to capture reference text (I.e. some reference of a particular word in a given cell with multiple words) within a Median(if()) formula? Usually I use the funky “*”&xyz&”*”, where xyz is the word I’m looking for, but isn’t working in this formula I have down:

=IFERROR(MEDIAN(IF(Data!$AR:$AR>0,IF(Data!$Y:$Y>0,IF(Data!$M:$AM="*"&D$345&"*",Data!$BR:$BR)))),"")

I’m getting married this year in Vegas (was planning on next year) purely because I can’t afford how much I’m taxed.

Hello, how much does an analyst /associate/entry level management consultant make in Germany? I am in Munich and I earn around 56k/year Gross. What are your thoughts?

Hello fishes,
Please help me unlock dms with likes

Thanks

What's your best practice for social?

I got offer in Pwc KSdc @Bangalore any idea till when will we get work from home as my home town is at Trivandrum, Kerala. Any option to choose work from home ?

Hello everyone,
Anyone here who have gone through the tech interview round with Mindtree on or around 19th November 2022 ?

Hi Fishes, I'm currently a Data Scientist with 4YoE in Data Science, ML, MLOps, I'm targeting MAANG companies. What should be the approach that I should follow. I have no prior experience in DSA and competitive programming

Customer Success manager vs Relationship Manager - Is there a difference?

Anyone interviewed with a state department of revenue? I’m really excited about this opportunity but I don’t want to come off as too eager/weird. Any advice on shining in the interview?

Has anyone used Qualtrics beyond their free survey platform? Interested in the online recruitment and panel management services.

My partner of 5 years ended our relationship last night. I’m shattered and feel absolutely sick, and I know the healing isn’t going to be easy. We were on the verge of an engagement and I was ready to spend the rest of my life with him.

I don’t know how to approach work during this time. I think I can get by, but I’m definitely not 100%. Should I talk to my boss about it? My team is close-knit and comfortable around each other, but I don’t know if it’s “appropriate.” What would you do?

Ughhhh I feel so nauseous all day every day. I’m 8 weeks today and miserable. I have never felt such a constant unwavering nausea.

Can we create an auditor labor union? All in favor say aye.

What is the best platform to buy crypto? In terms of fees, interface and etc. Complete newbie here.

Is appraisal for ifs at par with advisory? What is the new model?

All- best resource for buying designer bags?

Too soon to book a Christmas/New Year vacation abroad? Think we will be vaccinated by then?

I’m copying a report into workbook but the columns don’t line up to the report is there something I can do like to make it if this column name copy here. Not sure if this makes sense. I just fell like it really manual and there has to be an easier way

I have a large dataset and when I filter, I keep getting up pop ups that say “fixed objects will move”. How do I get this to stop?

Thoughts on learning VBA? Is it useful in consulting? Many people argue Python is better to learn overall?

Does EY’s version of excel have Xlookup? I don’t see it

Is there a text to rows (instead of text to columns) trick?

Does anyone know why negative IRR sometimes gives you a NUM error? A lot of googling and experimenting but cannot pin down what’s going on.

Index Match > Vlookup

Anyone work on a Mac and use parallels when in need of excel? If so, does it work or is it a big no-no? My work going forward will not primarily be excel, but I have to use it on weekly/monthly basis. Might also have to use some Power BI. Would love to go back to working on a Mac but excel has stopped me from buying one…

Can I write a macro that will fill out a table of information based on cells that have comments on them? For example, if G12 has a comment, I want to pull text from that comment + data in A12.

I’m looking to get a second laptop strictly for the use of excel & financial modelling. I currently have a Mac and would prefer to spend around $500 CAD. Any suggestions?

Can someone help me with recoding surgery question into binary variables? I’d so appreciate your help! TIA

Would someone please explain in a simple way when to use an array? Is it for every index match formula every time?

I know this is for excel, but any Tableau experts here can let me know how to present my mixed (countries, states, provinces) data on a map. I’ve tried dual axis but still not where I want it to be.

So i have a list of companies in a list (column A), and a “Y” next to them (column B) if i want to include them in my dataset.
Is there any way i can make a variable list, ie below the full dataset, of just the companies with “Y”, and it being dynamic?
Can post a screenshot tomorrow if useful to explain

Problem:
There is a table. Column A:D are mapped to column E with unique records. In a new column (Q), there is a list of values that that contain any randomized value from Columns A:D. What is the syntax to map Column Q to column E?

Is using INDEX/MATCH the right direction?