u/sriautomations

▲ 372 r/excel

That 5-minute task in Excel

Me: This will be a quick 5-minute Excel task.

Excel: Interesting.

5 minutes later:

  • Why is the formula returning #N/A?
  • Who merged these cells?
  • Why are dates stored as text?
  • Why does one value have a trailing space?
  • Why is there a hidden column Z?
  • Who named this file Final_v2_Actual_Final_UseThisOne.xlsx?
  • Why does the pivot table say 0 when my eyes say 47,382?

2 hours later:

  • Learned three new formulas
  • Questioned my career choices
  • Muted my entire family
  • Created a masterpiece no one will ever understand
  • Saved the file as Final_v2_Actual_Final_UseThisOne_REALLYFINAL.xlsx

Boss: Looks great. Can you make the header blue?

reddit.com
u/sriautomations — 2 days ago