•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
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?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#rows.com
#AI formula generation techniques
#formula generator
#Excel
#formula
#pivot table
##N/A
#Final_v2_Actual_Final_UseThisOne.xlsx
#formulas
#merged cells
#dates stored as text
#Excel task
#trailing space
#hidden column Z
#saved file
#header blue
#file naming