Identify Double Entries

maxcel · Mar 14th 2008

Dear all,
Is there any simple way to find double entries,other than assigning any
macros to the sheet.such as conditional formating.i need to need to enter more than 100 nos,if a number is repeated it should be highlighted

Regards,
Maxi

Dave Hawley · Mar 14th 2008

Re: Identifying the double entries

Use Conditional Formatting for the duplicates. highlight duplicates

Simon Lloyd · Mar 14th 2008

Re: Identify Double Entries

Highlight your enitire used range, give it a range name (say call it MyRange), then select conditional formatting and using formula is add this: =IF(COUNTIF(MyRange, A1)>1,TRUE,FALSE)

Identify Double Entries

Participate now!

Share