What is your favorite new or recently discovered formula? One that I’ve been using a lot recently is MAKEARRAY. I’ve found it to be incredibly versatile in making dynamic worksheet features that were never possible before without VBA.

Best influencer search tools or strategies for sourcing?

How do you make connections at weddings when you barely know anyone? I feel like it’s always awkward smalltalk and at some point you’re just drunk and wanna go home.

How many days are you in the office?

Anyone ever left a job after 5 months? If so, how did the manager take it and did it ever impact your career in the long run?

Curious... any fellow females living in Sydney, Australia? 🌈

Do you know what today is, today is the day I am now allowed back to office as our vaccination requirement was dropped? I still can’t go to our office in NYC and possibly some other jurisdictions and we do need to follow client rules to visit them.
Have any of other Big 4 made changes?

Curious if this is going to happen to others - I quarantined w/ my husband 24/7 for the last 10 weeks, he left 4 days ago to visit a friend. I’m having severe separation anxiety beyond what is normal

The nail on my second toe hasn’t been the same since I ran a half marathon a few years ago. It’s gross and totally messed up and it doesn’t seem to be getting any better. Do I see a podiatrist for toenails or a dermatologist?

I just learned that I get to argue all of our pre-trial motions and do a direct examination at an upcoming trial. What are your best tips for preparing and setting yourself up for success? I want to hear them all! I’m beyond excited for the opportunity. It’s for our biggest client, so I really want to impress!

Affordable PG for Boys

Shared accomodation available in 3BHK
Location: Pimpri Area (Pune)
Landmark: Pimpri Station Rd

*DM for details*

Rent: Rs.3500 per bed/per month
Deposit: Rs.5000 per bed

- Fully Furnished
- Direct Owner
- Car & Bike parking available
- Standalone Building
- Electricity bill will be shared equally among all tenants
- Rs.1000 to be paid by tenant for notarized agreement
- Maid charges (for cleaning room) included in rent
- Max 3 people in 1 room

Anyone heard of Alkali Partners? What’s their pay/hours/culture like?

Hi Optum fishes. When does Optum send laptop if joining date is on 25th Jul? Also, how is joining process for 6yoe folks in Optum,

Any good wedding ring sources aside from Blue Nile?

💆Teacher Self-Care!

What are ways you create balance between work and life and help yourself destress?

Drop your insights below and help another user!

What is salary range/band of L7 Engineer profiles i.e. Sr Software Engineer, in MasterCard India ?

Took PM robitussin instead of DM 🤦 mad tired right now..😴

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

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.

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

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.

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).

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.

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.

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

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

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?

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!

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

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)

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

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?