Finding duplicate values

[mj6987]

Is there any function to make Excel search down a column looking for an
duplicate values in a column (i.e. where any value in the colum
matches any other)

I realise this could be done by sorting the column, then having anothe
column which subtracts each cell from the previous, and then ye
another column that uses an IF statement to check for zeroes (i.e
duplicates), but is there a quicker way?

Thanks

 

[Stephen Bye]

Select the entire column
Use the Format > Conditional menu option
Set type = "Formula is"
Set formula =COUNTIF(A:A,A1)>1
(replacing A with your chosen column)
Press the 'Format' button and choose how you want the duplicates to be
highlighted
(e.g. different font colour)

Is there any function to make Excel search down a column looking for any
duplicate values in a column (i.e. where any value in the column
matches any other)

I realise this could be done by sorting the column, then having another
column which subtracts each cell from the previous, and then yet
another column that uses an IF statement to check for zeroes (i.e.
duplicates), but is there a quicker way?

Thanks!

creating financial statements

 

[mj6987]

thanks Stephen that's just what I wanted - you're a genius!