Does anyone know if I can conditional format a cell for containing a given formula? Trying to design an excel “class” where I highlight a cell correct if you use the formula you are supposed to.

R/GA layoff updates: 20 cut in Portland today, bringing stateside count close to 100 on the year. No official statement from Bob.

How much do you pay per lb for wash and fold?

Hello all,

I am currently working as a Data Scientist at Capgemini. I have 2.4 years of experience and I am looking for a change. It would be a great help if any one of you have any open positions at your organization and can refer me for any such opportunities.

If you need any details, I can share that in the comments.

Hi everyone! Can anyone tell me what you make as a typical banquet/events manager for salary or per hour? I’ve worked for Marriott/Bonvoy at the Ritz and for the Curio Collection with Hilton as a bartender/server/banquets captain. Now I’m working for a privately owned hotel and as a manager role in Banquets/Events. Because of pandemic times, what is everyone else making?

When did you tell work about your pregnancy?

What big firms let you get to manager and above with an MBA and/or EA for tax?

I've recently went to a restaurant and saw a robot waiter, I thought that was the coolest thing. What do you all feel about this shift in the restaurant industry?

I need help fishers (desperately). I'm moving from pit to dal for work. Any fishers know of good/great interstate movers? looking for recommendations

Does PHR certification help in India, as this is globally recognised how much valuable is this currently in indian job market.

Do we got some good offers or its another certificate just to add to CV after so much of investment & time I don't want to get this wasted !!

Need suggestions ??

I recently got diagnosed with ADHD. I'm 31 and found this only because b school and post mba consulting job was/is much more challenging than anything I did before. What I'm confused about is that even as a teenager I could read entire books overnight. But the last two years of high school I started selectively zoning out and the problem has become worse since. I just realised it now. My doctor has suggested treating depression (I was also unaware of this) with Wellbutrin first (contd)

Any openings for .net MVC 9 years experience pune location

Thanks in advance

Hey guys.. anyone looking for good friend... Getting saturated with wfh :(

Anybody use Flaviar and recommend it? Referral discount?

Do you ever feel like someone is gaslighting you? + 10 if you've seen the movie 🎥 👍🏼

Hi all. I am looking to crack into the pe value creation space. Any tips or recommendations? Mckinsey senior EM and LBS grad with some early tenor investment banking experience; currently based in the middle east working for a public sector infrastructure player.

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

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.

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.

Does anyone from PwC have a list of the favorite groups shortcuts for excel? Please provide. Much appreciated .

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

Would anyone be willing to teach me vlookup?

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.

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

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!