Inky

For more advanced formulas, look up INDIRECT and LINE(). It lets you have one cell that contains a reference to a column number, combined with current line and you get the content of the cell it references. It might sound complex but I found it very useful lately.

Actually, I had forgotten about INDERECT and LINE. Saw someone else use that once - can be very cool!

Yup, I added it to the weekly games tracker to detect whenever one column exceeded a value. Since I'm using a different combination of columns every week and the sheet contains 9000 lines, I needed a dynamic formula where one cell identifies this week's column and then INDIRECT + LINE addresses the cells in play.