Hi,
I've always wondered if it were at all possible to refer to columns by putting the value in a cell. For example, if I had "D" or "4" in cell A1, could I use this in formulas then? Like count(a1:a1) - but I'd like it to count column D if that makes sense?
I've thought about this purely because I might have a sheet with several formulas and I need to change the column which means going through and changing them manually. If I could use a cell reference, I could copy the sheet and then just change one thing.
Bookmarks