gazingdown
Board Regular
- Joined
- May 21, 2003
- Messages
- 109
I need to reference the current column. How do I do this? e.g I want to intersect a row with a value in the current column. e.g. the formula in cell C2 = the intersect of row 1 and column C. In cell D2 it'll need the result of row 1 intersected with column D and so forth.
Can I do this without changing to R1C1 notation?
Can I do this without changing to R1C1 notation?