Chip Pearson has lots of techniques at:
http://www.cpearson.com/excel/duplicat.htm
> How do I identify when a cell value changes in a long
> column of numbers. I have many duplicates in this column
> and would like to sort the column and then identify the
> cells when there is a change in value.

Signature
Dave Peterson
ec35720@msn.com
>-----Original Message-----
>Chip Pearson has lots of techniques at:
[quoted text clipped - 10 lines]
>ec35720@msn.com
>.