Loading…
3
Coworker told me my Excel formulas were too nested and I should use helper columns instead
I spent 6 hours refactoring this huge spreadsheet for our Q4 reports after he showed me how breaking it into 4 smaller pieces made it easier to audit and now I can't believe I was cramming everything into one cell like a fool - has anyone else had to relearn basic spreadsheet organization from a simple comment?
3 comments
Log in to join the discussion
Log In3 Comments
the_henry5mo ago
Man that hits close to home I had to completely rework my whole inventory tracking system after a coworker said the same thing.
7
nathan_foster605mo ago
A good spreadsheet with some basic validation rules would've saved me weeks of that headache.
5
barbara3995mo ago
Yeah, that inventory rework pain is real. Sorry you had to go through that.
4