News for hackers. Stuff that matters.
Re:Ask HN: What are the biggest problems with spreadsheets? by misterdata on Friday July 24, 2015 @03:34PM (#9944609)
Use Excel's tables feature, and it will more or less force a column to contain the same formula for each row (or a numeric value). In these formulas you can refer to other cells in a row by column name.

https://support.office.com/en-ca/article/Overview-of-Excel-t...

There are no comments on this comment yet.