Odd question

Would you rather give up VLOOKUP or Conditional Formatting forever?

Tough call, I know. One helps you find meaning, the other helps you make it pop 😂😂

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

Easy, vlookup can go. So many other more efficient formulas to get the same result.

like

Haha totally

Assuming I keep xlookup, then vlookup can go.

like

It’s definitely more versatile

Related Posts

Is anyone here knows about wipro ehs/sustainability practice? What are the pros and cons?

like

I am looking for Service Virtualization roles
Tool: Devtest/CA Lisa
Exp: 7.5y

like

Hi Folks, there was an image which was showing the fixed and the corresponding take home salary? Can anyone share it over here?

like

Will rent in jersey city waterfront apartments (from Paulus hook to Newport) decrease this fall? $3500+ for one bedroom is insane…

like

How is the onsite opportunities in the coforge..?

HR called me and said this position is for onsite once the border gates are open...? Can i believe HR words..?
I am interested in Onsite opportunities.

like

Hows the appraisal number in coforge for this year ?? Nd also how much variable did you guys received ??

TFW someone tells you they quit and you can't discuss it because but damn is it going to affect next busy season...

likefunny
like

Almost 12 weeks. Still feeling sick in the evenings. Anyone? Please tell me this will end soon…

like

How do you guys think about placing limits on your watch collection?

like

Senior revving up to manager promo. Only nervous about one thing at the manager level which is having to answer pointed “Why??” questions from higher up clients on live calls. Any one else work through something like this? I’d appreciate any tips or suggestions as I really suck at dealing with unexpected push back.

likehelpful

I been thinking about buying a 3bed and 3bath house or a condo. I haven’t had much luck in finding one so I started thinking about 4 bed and 3bath. I am single and I don’t have any plans to marry or have a partner staying with me. Is there anyone who’s single living in a 3 or 4 bed house by yourself ? Please share your experiences from all aspects. The only thing that makes me think weird is, it’s too much space for one person ☹️

likefunny

So it isn’t the car after all !!!

like

Hi Folks, how are you doing?

Did anyone else get a ridiculous rent increase this year?

like

Anyone out in Philly? 25 M Here

like

Can someone help on how to get a burner?

funny

I have resigned from EY GDS on the e-exit portal a few days back. What are the next steps that I need to do.
Also, when will I get a mail to submit my assets and for any other formalities.

like

Joining the trend😊. This is my roommate and he desperately wants my DMs activated.

Post Photo
likeuplifting

Hey Sharks,
How much should one expect in a top consultancy firm, back end role (reasearch team) ?
Location: Mumbai
YOE: 7

Additional Posts in Excel Genius

Does anyone know any shortcuts for the “Refresh All” button without having to always click Data->Refresh All every time I want to refresh the live data? For a Mac btw pls thanks!

Post Photo
like

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

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

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

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

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

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

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

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

like

How do you fix microsoft excel cannot paste data error?

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?

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

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

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

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

like

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

like

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

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

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

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!

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