Sorry this is such a dumb example hahaha, but does anyone know how to do an index match formula utilizing indirect as well so you don’t have to write 3 different formulas for each separate tab?

What’s the story with Army account at DDB? Heard so many different things about their leadership and culture.

Who did the Lean Cuisine #ItAll campaign?

What is the maternity leave policy of PWC and for how many children it is available?

DBS Bank vs Bank of America (BA Continuum India Pvt. Ltd.) Agile Business Analyst role,

Which one to join?

Culture, Learning and Growth(Knowledge +Financial) wise?
Offered CTC is approximately the same

What’s the best way to break into life sciences VC/PE from a LS consulting background?

Feeling lost in my career (10 yoe, 9 in consulting). Anyone feel this before and how did you get through it (career coach, books, etc)?

Moving to Boston from NYC and work in Cambridge. I’ve been recommended Back Bay, South End, and Seaport. Where do you recommend? Where is best for dating life?

Is anyone else worried about an upcoming market crash, similar to the dot com bubble?

Used to work at JPMC in a compliance role. Left for a few years. Interviewing for a WM KYC Onboarding Officer Associate position but have yet to speak to HR. Have interviewed with hiring manager and interviewing with ED today. The position wants 5 years of experience. Worried about the salary. Anyone know the range? Glassdoor and other places have it all over the place

So, I truly enjoy wealth management, corporate and institutional solutions and being in a managerial position with 5+ years in this field and in a true management position. I have a B.s in Business Administration and MBA in Global Business Management Currently hold Series 7, 9, 10 and 66 and I’m looking for great opportunities in the Atlanta market. All the help, referrals and guidance would be much appreciated! Was at JPMC before but had left to get managerial experience. I miss JPMC!

Recommendations on bathing suits for guys? I like the Vilebrequin / Mr. Swim style, but don't want to spend more than $50

I’m seeing prices for watches that used to depreciate heavily pre-2020 - but suddenly began to hold value because of the Rolex craze - tank like crazy. IWC, Panerai, Omega etc. you name it. Finally!!!!

Anyone in Big 4 health (payer) consulting practices have any insight in to current or upcoming openings for SM level roles?

Are there many legitimate ethical hurdles when switching from insurance defense to plaintiff’s work? I’ve always seen myself as a plaintiff’s lawyer, but ultimately took an ID job out of law school (better salary, no real opportunities at plaintiffs firms that I liked). I like what I do—so far—but I’m constantly thinking about whether the grass is greener.

I messed up my screenshare in a meeting with 2 colleagues and showed my personal email that had scheduling info for my onsite interviews with another company. I closed it but it was up long enough for them to see it. Now they both pretend like they saw nothing and I felt panic for some reason. How were your experiences when letting it out the bag early like that?

What is the protocol with talking with recruiters? I'm not pre se looking to move right now but if something with more money and flexibility regarding location opens up then I'm not opposed.

Is it wrong to talk to them about possible opportunities?

Hello Folks!

During work from office days, a representative from third party vendor organization used to visit the Gurgaon office during the Investment Proof Declaration days to help folks with "rent agreements, PAN number and rent slips" (ahem!! ahem!! IYKYK) and we were able to claim tax deductions.

Is it still happening there? Also, does anyone have a contact for them?

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

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?

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?

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!

How do you fix microsoft excel cannot paste data error?

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.

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.

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

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?

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!

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

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

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

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

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