Hi all,

Why this is not working when reffering other than A1 cell (row 3) ?
=MATCH(A3,ROMAN(ROW($3:$3999)),0) - does not work??
Thanks for hints,
Jan


"Lori" wrote:

=MATCH(A1,ROMAN(ROW($1:$3999)),0)

ctrl+shift+entered with Tools Addins: Analysis toolpak checked.