What is your favorite new or recently discovered formula? One that I’ve been using a lot recently is MAKEARRAY. I’ve found it to be incredibly versatile in making dynamic worksheet features that were never possible before without VBA.

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

I use “textbefore” and “textafter” and xlookup a lot.

like

I haven’t seen textbefore and textafter, I’ll have to check those out!

Now that you mention MAKEARRAY, I’m curious how you use it. I’m somewhat familiar with dynamic array functions but MAKEARRAY was at the bottom of my list in terms of what I thought could be useful.

like

Sorry for the phone screenshots 🤷‍♂️

Post Photo
like

Not a particular formula. But I’ve been using AI to write my formulas. I can basically get anything done without spinning my wheels.

like

I’ve heard of people doing this, haven’t tried it though! I’ve even seen some add-ins so you can do it all right in excel.

like

I think it has been getting more popular as of late, but I do find being very good at LET, FILTER, UNIQUE, VSTACK, and XLOOKUP (and being able to combine them properly) still allows me to be "the excel guy" in the office. Also, learning how to make Alteryx interact with Excel has been a major game changer

like

Alteryx interact with excel?

Not recent but Vlookup is pretty awesome

like

I find the syntax for index match to be much cleaner than a double Xlookup when searching a grid.

like

Related Posts

Best influencer search tools or strategies for sourcing?

like

How do you make connections at weddings when you barely know anyone? I feel like it’s always awkward smalltalk and at some point you’re just drunk and wanna go home.

likehelpful

How many days are you in the office?

like

Anyone ever left a job after 5 months? If so, how did the manager take it and did it ever impact your career in the long run?

likesmart

Curious... any fellow females living in Sydney, Australia? 🌈

like

Do you know what today is, today is the day I am now allowed back to office as our vaccination requirement was dropped? I still can’t go to our office in NYC and possibly some other jurisdictions and we do need to follow client rules to visit them.
Have any of other Big 4 made changes?

like

Curious if this is going to happen to others - I quarantined w/ my husband 24/7 for the last 10 weeks, he left 4 days ago to visit a friend. I’m having severe separation anxiety beyond what is normal

like

The nail on my second toe hasn’t been the same since I ran a half marathon a few years ago. It’s gross and totally messed up and it doesn’t seem to be getting any better. Do I see a podiatrist for toenails or a dermatologist?

like

I just learned that I get to argue all of our pre-trial motions and do a direct examination at an upcoming trial. What are your best tips for preparing and setting yourself up for success? I want to hear them all! I’m beyond excited for the opportunity. It’s for our biggest client, so I really want to impress!

like

Affordable PG for Boys

Shared accomodation available in 3BHK
Location: Pimpri Area (Pune)
Landmark: Pimpri Station Rd

*DM for details*

Rent: Rs.3500 per bed/per month
Deposit: Rs.5000 per bed

- Fully Furnished
- Direct Owner
- Car & Bike parking available
- Standalone Building
- Electricity bill will be shared equally among all tenants
- Rs.1000 to be paid by tenant for notarized agreement
- Maid charges (for cleaning room) included in rent
- Max 3 people in 1 room

like

Anyone heard of Alkali Partners? What’s their pay/hours/culture like?

like

Do IBM has offices in Mumbai location??
More precisely for SAP practise in Airoli?? IBM

like

Hi Optum fishes. When does Optum send laptop if joining date is on 25th Jul? Also, how is joining process for 6yoe folks in Optum,

like

Any good wedding ring sources aside from Blue Nile?

💆Teacher Self-Care!

What are ways you create balance between work and life and help yourself destress?

Drop your insights below and help another user!

like
like

PwC India How many days does it take to put us in a project pwc india LOS Advisory- Tech consulting Team PwC India PwC

Onboarding formalities completed on 17th June

like

What is salary range/band of L7 Engineer profiles i.e. Sr Software Engineer, in MasterCard India ?

like

Took PM robitussin instead of DM 🤦 mad tired right now..😴

likeupliftingfunny

Additional Posts in Excel Genius

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

like

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

like

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

like

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

likesmart

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

like

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

like

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.

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

like

Anyone know what these badges are?

Post Photo
likefunny

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

like

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?

likehelpful

I’m helping my GF with excel and need help lol. She works at a hospital and is trying to make an excel schedule for doctors to reserve rooms. She wants drop downs for days of the week (column K) and also different drop down menus in column P for the reserved time slots.

Is it possible to do this with two sets of drop downs (days of week + time slots) and not use index match here? She could make 5 tables for each day of the week, but prefers one table that can be easily navigated by doctors.

Post Photo
like

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!

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

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

like

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

like

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)

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

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

like

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?

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