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

Hi rsenn,

Thank you for providing a sample file, it was very helpful.

Cheers,
Sam

rsenn wrote:
I've posted a small file for you. This small file shows how to get th
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 ca
merge the formulas.

http://www.anywhereenterprises.com:8...sOWOAApQZOAAY5

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200511/1