Been in consulting for over a year and wondering what other formulas other than index/match and vmatch is useful.

Posting as :
works at
You are currently posting as works at

Xlookup

Related Posts

Y’all know of a standing desk that doesn’t make the monitors shake when typing?

funny
like

Hi Fishes, Could you guys share details of medical insurance provided by Amex for employee & parents, what's the max coverage and premiums. Are pre-existing conditions covered for parents as well ?

like

A recruiter let me know about a lit. opportunity at an AmLaw 100 firm.

In my opinion, I don't need a recruiter to have a chance with this firm, but do I have any obligation to use them instead of just reaching out to the firm directly?

likehelpful

Has there been a time where you had a hard time selling a property? If so what made it hard to sell and how did you finally sell it?

like
like
like

Product based company with low package or service based company with high package

like

I just want to say this is the most positive, uplifting bowl 🥹

upliftinglike

I just started Wellbutrin last week and, I know it takes a while to kick in, but the energy it’s given me the past week is amazing. I can actually focus on tasks, not get lost in my thoughts, and actually wake up on time. I hope it stays like this forever.

like

Anyone not going to use their Icon pass discount? I’ll be switching from Epic to Icon!

like

Anyone here get a onewheel to keep the pow vibe alive for the summer?

like

Hi folks, I’m trying to learn how to snowboard…where’s a good place to learn?

like

Does anybody else get extremely, unhealthily anxious that they're not getting out there enough, that they're missing great snow, that they're stuck inside working, that there's only a few months of the season and that it's all-or-nothing?
The thought of having to find the best run, the fewest crowds, the best pow days, etc. all make me physically uncomfortable.
Even just watching the videos of snow fall on
Tahoe is making my heart race spike.

like

This is for my real estate agents. I’m brand new into the business and I adore the work. What tips or pointers can you give to a new agent- I’m in Las Vegas if it helps to be specific. If anyone has any book recommendations that’d be awesome as well. I’m looking to learn anything and everything. For example, learning what I can and can’t do to make a deal close

like

How much salary LTI can offer to Specialist - Data Engineering (P3 Grade) position ? YOE- 5 CCTC - 12.65 Please suggest so I can negotiate accordingly. Infosys Larsen & Toubro Infotech Accenture Capgemini Wipro LTI Information Technology EY PwC IBM Tata Consultancy Deloitte

like

Can anyone refer me to the position at JPMC? job ID : 210283303.
Sorry for urgent post, this position is closing in 30 mins :(.

Please ping me for my email id or resume.

like
like
like

How does a variable pay decided at JPMC.
HR only confirmed the Fixed portion of CTC but not the variable component and said this will be known to once they send Offer letter.

like

Additional Posts in Excel Genius

Feeling behind at work. I’m relatively new to data/financial modeling. Any advice on learning how to take a client data set, cleaning it up, and turning it into a model for analysis? I’m a new consultant at a boutique and I’ve basically received no training at my company on how to use Excel to do this. Additionally, is this fair game for a new analyst to understand how to do this without any prior training?

like

Not Excel but Outlook: anyone know how to make it so others can’t recall messages from your inbox?

like

Does anyone know of a good excel training online (pivot tables…filters…) ? (Preferably free)

like

Anyone know of an excel Add-in (preferably free) that lets tracking formula in a cell?

like

What are your favorite excel macros to make you more efficient at work?

like

Hello Excel champs , need your help with the below screenshot. First table contains the master data with Parent and Child item details. Agenda - is it find out all the child items pertaining to make 1 unit of the corresponding parent item. In this example I took Parent Item A and exploded all the Child items and the required units to make 1 unit. Now the challenge is that I have a master data of 250,000 line items and I am trying to figure out the exploded version of all the Parent items.

Post Photo
likesmart

To all heavy Excel users, what brand laptop are you using and how’s it working for you?

like

What’s everyone’s favorite keyboard? Thinking about switching mine up

Looking to use an XIRR formula with an “As of” date option (as of 12/31, 9/30, etc…) So it would essentially stop pulling dates and values once it hits the date in the “as of” date cell.

Any ideas? Much appreciated.

like

Is Macabacus or any other add-in actually worth it for Excel & PPT? In LMM - MM M&A roles.

likehelpful

If I have a very large pivot table with a bunch of subtotals, is there an easy way to make those subtotals actually formula driven? Other than just copying the values from the pivot into a new sheet and converting the hard-coded amounts to formulas manually?

Can anyone provide a reference to how to efficiently create and link an excel spreadsheet into a ppt (and make it dynamic). Thanks in advance!

like

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?

like

I have been given a csv file and one of the columns has multiple properties. I want to split each of the properties into their own column. However every row doesn’t always have them in the same order and may have slightly different properties. Is there a way to sort this efficiently?- picture for reference, columns v onwards is how I have split with text to columns currently. Any help is greatly appreciated

Post Photo
like

What's the equivalent to a sumifs formula but instead of #s I want to bring in names. For example, i want to return a client name but only if it meets two criteria.

like

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.

like

Help this is probably dumb. I have a workbook with 30 tabs. Is there a quick way to separate each in to its own book or should I copy one a time?

like

I am trying to create a formula based on data type geography. I want to ba able to write if(cell=NY,,) but I get #value.

How do I get formula to recognize the text of a geography data type?

like

Any macro experts that can help changing this 3 generation family tree generator to a 6 generation one (template link provided in comment below)? Provided by Microsoft but I have no idea how to edit this macro to allow more generations, and this is the easiest to generate template I've seen unfortunately

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal