When the war zone is Excel and your only weapon is Ctrl+Z lol. Who else has a lot of reports due this week?

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

Version history is your friend.

likesmart

Related Posts

If someone goes to Dubai as a third party contracter for job, is it still possible to get a job in India and come back.?

like

I’m on an estrogen patch and I feel like it’s making me really sad. Has this happened to anyone else?

like

Hi,

My team at Fractal is hiring for various roles in analytics, like consultant, data engineer, data scientist across all bands.

Now is a good time to be in Fractal.
If you have 2+ YOE and have above skills, shoot me a DM

like

Where do y’all get shirts and pants from? Need a redo wardrobe

like

For those who use via fairly often: do you tip your via drivers?

like

Looking for a referral at Dell. If anyone can help, pls comment or DM. Thanks in advance :)

like

Hi 🐟 s , looking for .net developer opportunities with 7.5years experience.

Kindly share if any vacancies . Thanks in Advance.

like

When HR's literally means "There is no budget constraints for right candidate" 😄🤑

Post Photo
funnylike

Does anyone have an email address of the recruiter at Trailer Park?

I truly wish people could understand the emotional damage hoaxes, social media ploys, and ill-intended jokes have on others. It is a deafening feeling when schools become places of survival. Wishing faculty, staff, and students everywhere a safe and peaceful rest of the school year.

like
like

What if Elon Musk replaces Rajesh Gopinathan as the CEO of TCS?
All the useless managers will be fired?

funny

Anyone have connections to 360i?

like

How do y'all manage passwords ?? Esp absolutely critical ones e.g. coin markets etc..
Is anyone else paranoid about all this ?

like

Let us make predictions- who will win?
We can check this thread in 2 weeks time

like

As all vaccines' efficacy dip over time, I was thinking of getting booster shots of Moderna or both shots of Moderna or Pfizer for my parents (senior citizens) visiting the US from India in Nov.

They have taken both rounds of Covishield a few months ago. I'm looking for data if mixing and matching vaccine types are okay.

like

KPMG GDC is hiring for below positions. DM me or comment below if interested.

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

Just discovered a public slack channel (that very much should have been private) that a few women at my work have been using to bitch about the co-workers they don’t like. There’s a lot of very mean posts about several of the CDs, account people, producers etc. There’s quite a few hateful posts about me and my partner too 🙈 should I tell them?

like

Additional Posts in Excel Genius

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

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

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

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)

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

like

Anyone know what these badges are?

Post Photo
likefunny

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

Would anyone be willing to teach me vlookup?

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

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

Post Photo
likehelpful

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

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.

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

Still don't have xlookup. #fomo

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

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

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

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

likehelpful

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

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