Hi Domenic,

Domenic wrote:
Are you saying that A2:A10 might look something like this... ?

Yes

30

30
30

30
30 Row Number of LAST 30 with two consecutive instances

If so, what result would you expect? And to be clear, will there ever
be an instance where there's three or more consecutive values?

I would expect the Row Number of the LAST 30 with two consecutive instances.
There may be instances with three or more consecutive values BUT I only
require the LAST Row Number of those with two consecutive instances.

Cheers,
Sam

--
Message posted via http://www.officekb.com