undefined | Better HN

0 pointszurtri7mo ago0 comments

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.

0 comments

boppo17mo 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.

orand7mo 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.

boppo17mo ago

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

j / k navigate · click thread line to collapse

0 pointszurtri7mo ago0 comments

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.

0 comments

boppo17mo 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.

orand7mo 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.

boppo17mo ago

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

j / k navigate · click thread line to collapse