[zurtri]

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]

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]

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]

Oh, duh yeah. That's such a natural thing to avoid I hadn't considered it