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