Need question: What's your favorite excel formula?

like
Posting as :
works at
You are currently posting as works at
Highlighted IconHIGHLIGHTED

Alt + F4. It solves many issues with Excel

like
Recent IconRecent

Index/match or offset

like

Index match > vlookup and hlookup

like

Vlookup!

like

=INTERCOURSE(ME + YOURDAD)

like

IFERROR ❤️

like

Why would anyone ever use Vlookup over Index match????

like

S&1:
VLOOKUP(A2,B3:C7,2,0)
INDEX(C3:C7,MATCH(A2,B3:B7,0))
Which one looks shorter to you?

like

A3, yeah, but imagine if you need to insert a column between column 1 and 2, then vlookup goes haywire, while index match stays intact. Clearly, you know how to use both, so I assume you're aware of all pros of index match over vlookup... Still a puzzle to me though, why would anyone use vlookup over index match?

like

You need to better distinguish between needs and wants. You may want a favorite Excel formula, but you don't really need one.

like

Index match is dope

like

Index match is more efficient from a cpu processing standpoint as well. Will be faster with large datasets

like

Indirect (shout out to all my modelers out there)

like

SUM

like

Waiting patiently for concatif to become a real formula...

like

Don't learn VBA in 2017 please. Learn python.

like

=‘tab name’!<cell letter><cell number>

Saves so much time 😍

like

And the text function bundle deserve a shout out for when you have to clean and sort badly broken down data 🙏

like

It’s an add-on rather than a function but shout out to Power Query. Combines well with PivotTables for aggregations on clunky CSVs

like

Related Posts

Anyone know of mid-level copywriter openings in New York right now?

like

QA lead -10yrs exp... Longing for a change.. Plz DM me so that I can share resume

like
like

First time home buyers in the GTA: where are we moving to? I'm considering a 1500 sq ft igloo in Nunavut at this point.

funnylike

What should be expected package for Senior Bizops Engineer.

YEO - 7.9
Current CTC -13.13
Offer form another company -18.70

Could you please provide your suggestion .

Thanks in advance

like

Aya phir appraisal?
on a scale of 1 to 10 how dissatisfied are you?

I have got excellence review as "Highly Valuable".
What percent of hike i can expect with this review.

likesmart

Anyone here work for DCF? It wasn't listed as an employer.

likehelpful

❓I heard bny taken employee survey with few options regarding WFH policy at BNY.
Which option bny provided to employee on wfh ?
Result declared by bny on wfh policy ? Any idea 💡 on wfh policy at BNY ?

Hello,

I’m having 7years experience with CTC of 36LPA, where 32 is fixed. How much can I expect from zscaler?

Thanks

Got a 74 on FAR. Got a 73 last time I took it. Just kill me now. Ready to give up on this process. Going to lose credit for AUD now with REG not far behind. I studied so hard and really thought I

like

Not sure if other firms are the same, at EY we can add “🏳️‍🌈 I support inclusion” in our email sig. Most people from Unity ERG don’t. If you don’t, why not? Particularly during Pride month.

like

I have been giving interview from last 2 months and yet I haven't got a single offer and people here are getting multiple offers. Even if interview goes nice, I would get rejection mail.

I guess Luck matters a lot even if you perform well. There would be always someone who will do better than you.

I am getting demotivated, but have to continue trying hard.

I really wish luck could be on my side.

YOE- 6
CCTC- 8

likehelpful

Can somebody please refer me for Microsoft Germany? I’ll contact you with further details :) TIA

like

Is Deloitte Consulting better than ZS at Manager level?

like

What's your preference for plaintiff's side? Steady pay at approximately $120k with no bonuses, or a base salary of $70k plus a cut of what you close over a minimum threashold? Midwest-ish market. In both situations, you get a cut of what you bring in.

like

My boyfriend and I make 200K combined and live in NJ. We have $1000 in monthly car payments combined. That’s all we owe. Our credit scores are in the 800s. We have 50K to put down on a home. We have done the math and I know we can afford much more but he doesn’t want to buy more than a 400K home. I’m almost positive we can afford 500K and be more than ok. But then he starts to talk about how much kids cost and how we will be house poor and we won’t be able to afford kids. 🤔 Am I insane??

likehelpful

What would be a typical salary for a junior in house counsel role (3 yoe) at a publicly traded company in a secondary market (think Austin, Tampa, Charlotte)? I’m having a really hard time finding what a reasonable range would be. Most positions I’m applying to require desired salary in the application, and the truth is I’d accept anything north of 125k but don’t want to undersell myself and take a bigger cut than necessary coming from biglaw.

like

Which one is easier? Join FDD from FAAS or Audit?

like

Additional Posts in Consulting

SMs and Partners = Cardale Jones. Analysts and consultants = hospital kid

Post Photo
likefunnyuplifting

Are there any delta promotions going on right now?

like

Best alternative to Hilton loyalty? And will they match my status? Getting fed up with Hilton's poor customer service.

like

Has anyone left EY and submitted a wageworks reimbursement in their last two weeks that they got paid for?

like

Sunday is like the last glimpse of Venice prisoners used to have on the Bridge of Sighs before being taken down to their cells.

like

Tax senior wanting to go into consulting at Deloitte. What do I do? Go.

Would you rather get an MBA from any program of your choosing (all loans) or guaranteed 130K/year, 40 hours a week until you retire (no chance for raises/bonuses)?

like

Can someone help with the base salary range for a 6+ years experienced finance professional with FRM and CFA certifications in Big 6 firms in Advisory practice?

Also, what should be the expectations for joining bonus during the current times?

like

Good consulting books? Not talking case prep but a fun read about the industry and what it takes to succeed, etc. Thank you!

like

Best books to study for case-study interviews? Or methods people have used? Coming from the consulting industry already but not a pure strategy role so need to catch up to speed fast

like

Anyone in a DC area commercial office that's hiring? This federal work is killing my soul.

like

Has anyone used gliders that stick on tyres of office chair, for better movement over the carpet?

like

Interviewed at Deloitte 1.5 weeks ago, how long to follow up?

like

How much severance should you expect after getting booted after 1 year. I got 3 months salary

like

Good one Booz....

like

First year in consulting, is it worth purchasing a car this early? I’m living at home and about a 45 minute car ride away from my home office. Any suggestions? What have you done?

like

Got a random email from a supposed Amazon recruiter for a SDE position (which is not at all a fit). The email is amazon.com domain and there are no red flags in the body but it doesn't feel like an Amazon recruiter due to the tacky signature, etc. Has anyone seen this kind of cold-calling from FAANG recruiter?

like

Are any top consulting firms hiring for experienced analysts currently? I know ACN and some others are cyclical for resources 2-3 years out of college, but I’m looking to make a move sooner than fall

like

Is it not a good idea to look for a new job in the current/anticipated future economic state? Don’t love my job and want to make a move but not sure if I’m taking a big risk if the economy takes a downturn soon

like

Best place to buy an iPhone 7 and not pay 1K?

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