True story: I once nested so many IFs and ANDs in a single cell, even I couldn’t remember how it worked a week later. Had to draw it out on paper just to untangle the logic! hahaha

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

Gross.. use enter key to space out your logic so it can be read more easily

like

Haha yep now I do that to format in a way easier to understand

Use helper columns

like

Yess helper columns are life savers

"Let" really helps with decluttering long nested formulas. Takes a bit of time to get used to but is a nice way of repeating formulas.

like

Interesting I’ll try that

like

You could also drop it into an AI now and ask it to explain the formula. May or may not help. Sometimes it surprises me.

like

Haha I do this all the time or I’ll tell it to format it for me

Related Posts

Does anyone have any tips or insights on certifications or skill training I should invest in to help make me more recession-proof?

like

Hi Folks,

After the HR discussion, how many days it will take to receive the offer letter please. As of now status is showing undee consideration in the portal.

Hi fishes,
I'm looking for a switch in career.
I'm bit wondered which one should I choose as a career choice in Salesforce developer and mulesoft developer ?
Can anyone suggest which would be the best?

Hello...

Can anyone tell me what is the salary structure like allowance , facility , or other things in American express apart from CTC offered.@

like

Hello!
I’m a student majoring in Software Engineering. I’m starting my third year in a few months and have an internship where I’m learning more about working with an actual team on real-world projects. However, I feel like I need to do more to stand out and have a stronger software background. Anyone have any tips or suggestions for what I should do on my own time to strengthen my skills?

like

I'm working in the US under H1B, I got a chance to face an interview for another company. My current company started the PERM application also and results will be out within the next 3 months. Is it okay to transfer my H1B to a new company? Can my H1B transfer be denied? How long will my green card application delay if I move to a new company and start to apply for a green card from scratch?

like

What do you think is the actual income ceiling for software engineering, broadly? I'm genuinely curious and don't even know what's possible

likeuplifting

Consulting to buy side (public investments, hedge funds, mutual funds, etc outside of PE) - anyone heard of people doing this?

like

Need health problem advice from fellow consultants: pretty bad chronic arm pain from elbows down on both hands. More I use my hands/fingers during the day, worse it gets, up to not being able to sleep

like

Recommendations for a wfh office chair? Preferably on the lower end of the range with good height.

like

Can some refer me in cogni...
Data Analyst.
YOE 1.5

like

How it's like to work in Johns Hopkins Hospital ED as RN?

like

Anyone gonna be in NYC on Halloween? I’m hosting a happy hour until 8pm. I don’t want to just hang out in my hotel after. What’s goin down?

Love tossing out resumes that say "Founder/CEO", more every year

like

Oh, the beauty of the solo Sunday brunch ☺️🍳

likeupliftinghelpful

It takes me time to warm up & connect to new people, esp. in casual settings. Anyone any strategies how to deal with that? I see I am missing out on good and deeper connections.

like

Dating a girl with Barney's discount #winning

like

Have been offered 07B grade in ibm..
Wat will be the roles and responsibilities.?
Stack : Oracle ERP
YOE : 7.5

like

Does Amazon provides breakfast and lunch facility in its bagmane tech park office?

Also, will it be chargeable or free?

like

Question on sponsoring my sibling - If my Parents are US citizen and they sponsor for my sister who is married and age of 35. How long it can take for her to get green card?

Additional Posts in Excel Genius

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

like

Any book recommendations on excel modeling for real world business applications?

like

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

Still don't have xlookup. #fomo

like

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

like

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

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)

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

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

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

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

like

What are your top Excel ninja tricks? Ones that few people know...

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

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.

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

How do I compare two sheets to make sure they are identical?

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!

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