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