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

30


30
30


30
30

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?

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

Hi Domenic,

A column will contain multiple instances of the same numerical value, so A2:
A10 will contain only numeric value 30. This numeric value will at times have
consecutive duplicates (x2).

Cheers,
Sam