3 ms·

So very true. And then over time these Excel spreadsheets become a core system that runs stuff. I used to live in fear of one of these business analyst folks

by zurtri 1y ago

So very true. And then over time these Excel spreadsheets become a core system that runs stuff. I used to live in fear of one of these business analyst folks overwriting a cell or sorting by just the column and not doing the rows at the same time. Also VLOOKUP's are the devil.

boppo1 1y ago
Why also sorting by row? And why are vlookups the devil? my undergrad was finance, but I've self-learned a lot of CS.
- orand 1y ago
  It's possible to sort just a single column, leaving all the columns beside it in their original sort order. That's very bad if you want to keep your rows in one piece.
  - boppo1 1y ago
    Oh, duh yeah. That's such a natural thing to avoid I hadn't considered it