re: #210 Timothy Watson
A pet peeve of mine is people hiding columns/rows with no documentation in spreadsheets. Drives me fucking nuts.
And if I have this conversation against at work:
Other person: “Don’t delete the spreadsheet, just copy and paste the new data in, you don’t want to mess up the links!”
Me: “The new data is irregular in both columns and rows, I’m going to have to relink everything anyway. At least deleting the sheet wholesale will generate REF errors that I can search for!”
Two of my favorites:
— Range references that fail to cover the entire range
— Columns where the formula suddenly changes, occasionally just for a single record.