Is there a function that returns the row, column or address of the active cell?
I'd like to build a formula in a column that displays a character if the
active cell is in that row, such as:
=IF(ROW()=ROW(ActiveCell),"X")
Thanks.