I recently built a dynamic drop-down where the choices update automatically based on another field, using the INDIRECT and UNIQUE functions. Super useful for forms and making data entry foolproof.
Anyone else automate data validation for a smoother user experience?

Who built the cages?

Newly minted consultant here looking for financial advice.

So I just moved to consulting after B school, and It's more money than I've made my entire life. After paying for rent and living expenses, I have 6000$ left over every month. My student loan payments are about 1200/month at 7% interest. I still owe another 95K on my loan. I have the option to pay more every month and reduce my overall interest paid.
Currently I put about 3000 towards my loan and 3000 towards my savings. Cont'd...

Why are most Indians obsessed with Jockey?

I have seen this since college days...

How was Diwali for everyone? Do anything fun? I am exhausted after seeing so much family but grateful!

Creative projects to do as a summative for Of Mice and Men?

what phone can you get at bcg? how often upgrade. for NAMR

Got an opportunity for devops cloud engineer. So will i work on their legacy cloud platform or do they use other competitors platform too?

About 2,300 National Guard members will remain in Washington as deployment is extended through most of May

Style experts, Allbirds: yay or nay? Let’s hear it.

Is there a way to know your business unit prior to joining in techM?

Summer intern at BCG. I've been told by a few people that you need to spend your first few cases "earning your stripes" to gain staffing optionality or be servile/loyal to a pyramid to gain access to the cooler case work within that PA. It's seemed particularly emphasized at times.

Is this the standard at McK? I'm trying to guage the staffing optionality and openness of McKinsey culture to direct your random walk.

Side hustle or startup ideas for someone who isn’t technical/doesn’t code? Where should I look or where to begin? I don’t have any strong passions or specific skills that I’m confident in. What books, articles, blogs, orgs, events, people I should follow for inspiration that has helped you? I have some cash to invest and am looking for a part time hustle that can cash flow at least a little bit of money on the side.

Anyone have any recommendations for an interior decorator?

How do you count years of experience? Lets say you were a web master for 5 years. Then you transitioned into a proper UX role and did that for 5 years. Is that 10 years of experience or 5?

When is it normal to start taking depositions for a new(er) associate? Entering 3rd year at midsize firm.

How to get from 18 LPA to 50LPA, presently have architecture exposure along with DevOps and Operations for microservices with automation
I can guess few replies , still checking :D

I have submitted my background check for the new offer. One of my previous bosses I referenced and now I am trying to call and text him to inform but he’s not responding so I am worried. (Cont’d)

Why do people accrue prepaid expenses?

Steps to become project manager. Am a non IT person. How can I start my career as project management team

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 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?

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?

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

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

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

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

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

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

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

Any suggestions for a formula to calculate a running count of the number of incidences in a list? For example, in a list with A, B, C, B; I want to label A = 1, then the first B =1, and first C = 1, and then the second B = 2, etc. The list is in a column and there are thousands of names. TIA for your help!

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)

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.

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?

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

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?

Excel Rookie looking for a super simple formula to bring all information linked to a certain date in tab 1 to be organized under said date in tab 2.

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?