Favorite excel formula/tool that’s not vlookup, pivot table, sum,average and the other basic ones

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

Alt + F4

like

Madman

Index match, if error, concatenate

like

Index match match, to go across columns and rows!

like

Indirect. I ❤️ named ranges.

like

Thanks so much!

Literally concat and text to columns are my lifesavers some days

like

It used to be Power Query, but I do love me some text to columns

like

Xlookup (I know, basic) but it's so much faster than vlookup.

like

Alt+Ctrl+delete

funny

Substitute, trim doesn’t work 100% of the time as I unfortunately found out

OW1, I learned last week that trim won’t remove spaces between words it will only remove excess spaces. Substitute was the simplest solution substituting “” for “ “

Who uses excel lol

yeah wtf kind of take is this lol. i UsE pYtHon AnD R bEcAuSe I’m tOo gOod foR eXcel 🤡

SUMPRODUCT as tool for counting with more complex logical criteria

F1

Round
Ifna

Related Posts

How to get LTA and Telephone Reimbursement in salary EY India in if we do not claim it through bills?

like

I’m a senior associate and received an offer to join a very profitable client as general counsel that would open lots of doors professionally and financially. Problem is I’m super burned out on law and was planning on quitting law firm in the next few weeks and doing something else with my life. Someone kick some sense into me before I decline the offer.

like

I work for a fairly small company. We have had a lot of growth recently. I made a comment that I was not happy with the company culture. The CEO wants to meet. We have a good relationship. My question is…should I send a email with specific examples ahead of time or just keep it as an “on the fly” convo?

like

PWC Audit A3 to Senior Consultant, Risk Advisory at a very small firm? Thoughts

like

Can I get 11 likes to unlock DM, please?

like

Have the opportunity to become a Chief Strategy Officer of a 3 hospital system. Only catch is it’s in the california desert region… would have to leave a major city with friends and family for the job. What would you do?

like

Working as a Senior Accountant at Vanguard with my CPA; 3 YOE, Greater Philadelphia area. Took this job to give accounting one more try and while I don’t regret it I’m bored. Anything in finance more challenging/less box-checking? People have recommended public but I’m not interested in audit/tax or travel.

Planning a weekend trip to visit Big Sur/Monterrey/central Cali. Any tips/recs? Planning to do Airbnb and stay for three nights. We will have a car.

like

What’s your can annoying help with Capgemini invent Accenture and baringa manager grade total comp please?

funnylike

Do you work alone or with a team?

like

Anyone recently joined Bosch, is it mandatory to do ECG, chest X-ray and whole other bunch of tests??

like

Hi Fishes,

I have one offer in hand from a big company, however role and technology is quite not in the edge, while theres another company who is working with the edge technology and exciting projects, however they are not willing to give me same offer as the big company gave me.

what should i do?
I have 6+ years of experience, should i go for more learning less salary, or high salary less learning?

like

Random question but recommendations for nice kosher restaurants or bars around midtown west? My new associate mentee eats kosher and I have no idea where to take him!

like

I recently joined Capgemini by this friday it will be one month. I didn't receive any laptop dispatch mail or anything till now . I filled a survey form on joining fay for laptop dispatch after that nothing was updated about again.

Will we get the laptop dispatched mail if the laptop is dispatched??

Also yesterday I got a mail to attend office physically for all bench personnel. I rarely even completed 3 days in Capgemini.While joining recruiter said that atleast there will be 3 months time.

like

Looking to connect with recruiters who specialize in Operations, Strategy, Continuous Improvement, more specifically in health tech. Also Data Analytics... I have at 3 potential leads.
Each has over 10 yoe, managerial experience, and technical exposure.

like

Has anyone appeared for any interviews for company "bot mantra" ?

like

When did you find your first gray hair? And what have you done (I.e. root touch ups, etc) to cover it up? I’m 25 and have discovered a smattering of gray hairs :(

like

Damn I have availability for the rest of the week but I’m crying at the thought of reaching out. I just wanna study for the CPA without any “what are you working on” pings. I know I know I’m terrible.

like

Anyone ever buy the Westin pillows? I really miss them and need new king size pillows at home.

like

Additional Posts in Consulting

Facebook initial round to result timeline: it has been almost 2 weeks and should I send the recruiter a follow up email? Also do they use the application portal where you can check the status? Thanks!!

like

Free deposit of 50% of Elite nights from last night for Marriott Members. Sounds like Marriott really wants us to start going back and staying in their hotels.

like
like

matched with a senior manager at my firm on tinder, really been really hitting it off well. should i ask for a charge code for this? need more utilization

like

🐟 in Charlotte: best place to go watch the basketball game tonight? Any good sports bars?

like

Best consulting firms for strategy in the US besides the big 4 and MBB?

like

If money were no issue, what would you be doing?

like

Hi
Is there anyone here looking to hire a Strategy consultant? I've got previous experience across public and private sector and I'm now looking for a new challenge with one of the top consulting firms in the UK.
Any help would be much appreciated.

like

Has anyone done a long-term remote project for more than three months? I can work out of my home office, but doesn't it get isolating?

like

Ik it's not NYC or SF but the Chicago apartment hunt grind is getting to me 😪

like

Should I be expected to get birthday presents for my fiancée's siblings?

like

Question, if you get fired or laid off within the sign on bonus repayment period (normally 2 years) do you have to pay it back? Or would you only have to pay it back if you leave voluntarily?

like

🐠 🐟 Share your amazing hotel stories . I miss business travel … last time I met a client face to face was in Feb 2020. My most amazing hotel stay was in Toronto June 2018… checked into a Westin hotel and I was upgraded to a presidential suite ! I couldn’t believe it until I went to my room .

like

I want some opinions..

I have long diagnosed and bad ADHD. I have never really found a medication that works for me, usually I am able to focus more but my anxiety spikes to unhealthy extremes even when lowering the dose across all I've meds I've tried. (Adderall, Concerta, etc)

What works surprisingly well, is a combination of Matcha Green Tea and a low dose hybrid edible of THC: CBD (ranging between 1.25-2.5 mg each)

I've worked remote with this and I have gotten way more done each time.

like

Went on three dates in last three weeks. Two of them backed out when they came to know that I travel everyweek. The one left was unhappy this morning when I got up at 4 to catch my flight. FML !

like

Has anyone received an with the expectations to have your home office in City/State 1 then you request to be based in City/State 2? Were you successful?

like

National Debt now over $60,000 per citizen. 😱

like

I sit by a lot of admins and I have to say they work SO hard and their work seems consistently underappreciated by partners and staff; some treat them astonishingly rudely. Don't be that person.

like

Desi Consultants!! - who all are thinking of hiring Sima Taparia (after watching Indian matchmaking on Netflix) for finding your future significant other?

likefunny

When you're at work, single, and that somebody gives you the eye 😏

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

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

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