INDEX ? MATCH ?

[Emm]

Hi All,

I used to have a formula a while ago (lost the file) that found matching items in a list ... say Col A has a column of numbers used for unique ID purposes.

I had the cell change colour when there was more than one number the same. (conditional formatting)

in other words .. it would identify all same value numbers by colouring their cells.


any idea how I did it?

thanks..

keith

 

[PaddyD]

=countif(range,cell)>1

perhaps?

 

[Emm]

Thanks Paddy,

Yes that worked .... applied it to conditional format ...



keith