I've posted a small file for you. This small file shows how to get the
row numbers of the last and 2nd last occurances of numbers in a column.
It uses 3 columns other than the data column, but if you want you can
merge the formulas.
http://www.anywhereenterprises.com:8...OWOAApQZOAAY5i
--
rsenn
------------------------------------------------------------------------
rsenn's Profile:
http://www.excelforum.com/member.php...o&userid=29050
View this thread:
http://www.excelforum.com/showthread...hreadid=487810