Hate to break it to the programmers, but we Excel users are over here solving the world’s problems with one IF statement at a time.

Post Photo
funnylike
Posting as :
works at
You are currently posting as works at

One nested if, and one index(match()match()) at a time

like

Why not both?

like

If then else in powerquery is literally the same as if

If(condition,true(then),false(else)

Talking python it’s the same idea except instead of like using “or” you use elif (else if)

Related Posts

I need you help to work in you country i want know you country and your culture

like

What are Auditors making at start ups/unicorns? Obviously the Software Engineers are the ones making small fortunes, but what about Auditors? Are they granted a good chunk of equity as well?

like

Are IKEA furnitures worth it, like the sofa and the bed?

like

Hi Fishes!
I just got an offer from Quantiphi Analytics, Bangalore
Role: Data Engineer
Salary Offered: 16 LPA (14 fixed)
Current: 5.7
YOE: 3
Could you let me know if i should join this company? Considering its a startup and the offer is more than I expected

like

Anyone want to grab dinner at Battello one evening?

Recommendations for local meal delivery services?

like

Paytm: can i copy your homework ?
Ola: Yes but don't make it too obvious
Paytm: sure.

Post Photo
funnylike

How does a sole engineer at a company go about getting management to actually care how production machines run? I’m the only mechanical engineer at my company dealing with a half dozen cranky production managers who think that I can “work my magic” on a machine. It’s not magic, just ignorance about the machine actually works. How to I get a manager to stop caring about the end product long enough for me to actually teach them about their own machine?

like

Hi fishes,

I got selected for sps T4, however I'm uncertain about the job role , if anyone could give insight about how the role is and what are the growth opportunities it would be great!

Thanks in advance!!! 😊

likehelpful

If someone saves proprietary company docs in their own personal google drive and then shares with other people… how can I anonymously let the company know (not the company I work for)

like

Does anybody know which are the best in-house agencies to work for? Thanks!

like

Best movie ever?

like
like

Tomorrows race has so much potential to be really interesting; really excited for this!

like

Looking for non- fiction book recommendations. I just read Shoe Dog and loved it.

like

So our CEO asked me and a colleague to give a Start/Stop/Continue Mid-year review of our CIO who’s been our Head of Product for a few months (Our Head of Product left because of him when that guy came in)

We have a lot to say and none of the PMs approves the way he operates.

My concern is that it’s meant to be transparent but if we’re honest and he gets called off, he will figure out it comes from us.

Never been in that situation before, is it better to be completely honest or a bad idea?

like

I joined Amdocs in Smartops unit recently and I am not happy with the work I am getting, its production support. What to do now?

like

EY FSO FAAS (S1) vs internal consulting for a big PE firm(consultant)? I recently got two offers. Both are for technical accounting. Which one is better for career development in the next 2-5 years?

like

How many days does Deloitte take to release the offer for an immediate joiner?

like

So the question has been asked a few times in the main Big Law bowl but keeps getting derailed into a political issue. As someone with a more conservative disposition anyway I'm interested in the day to day of life and work in Texas as opposed to NYC (or similar).

So, what are the pros and cons of living in Texas and working in Texas Biglaw?

like

Additional Posts in Excel Genius

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.

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!

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

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

like

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

helpful

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

likehelpful

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

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

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

like

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

Excel Rookie looking for a super simple formula to bring all information linked to a certain date in tab 1 to be organized under said date in tab 2.

like

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

like

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

like

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

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
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?

Still don't have xlookup. #fomo

like

Any suggestions for a formula to calculate a running count of the number of incidences in a list? For example, in a list with A, B, C, B; I want to label A = 1, then the first B =1, and first C = 1, and then the second B = 2, etc. The list is in a column and there are thousands of names. TIA for your help!

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

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