Formula for Cross Referencing Numbered List
I have a table with auto numbered rows.
Requirement.
(a) A Formula in the last column that must reference to a selected auto numbered row in the first column. Later, in case a row or column is inserted, the reference must change automatically to match the new value i.e. relative referencing.
(b) Optionally, if the reference is clicked on, it must jump to the particular target row referenced.
Regards
|