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 7 days ago | parent [-]

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 6 days ago | parent [-]

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 5 days ago \| parent [-]
		Oh, duh yeah. That's such a natural thing to avoid I hadn't considered it