Just to be clear, if A2:A10 contains the following data...

6
6
9
3
5
7
7
7
4

....what would be your expected result?

In article <62cefd3c3cc94@uwe, "Sam via OfficeKB.com" <u4102@uwe
wrote:

Hi All,

Using a Dynamic Named Range "Data", I would like a Formula to return the Row
Number of the "LAST" instance of a duplicate numeric value - repeating twice
consecutively in the same column.

Thanks
Sam