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

Domenic wrote:
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?

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