Finding duplicate values

  • Thread starter Thread starter mj6987
  • Start date Start date
M

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
 
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)

mj6987 said:
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!


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
Back
Top