View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default To find duplicates in XL sheet?

Hi

Select your data (in this example A1 - A100) then click

Format|conditional format
select formula is
enter this formula
=COUNTIF($A$1:$A$100,A1)1
Pick a colour and duplicates will be hughlighted.

Mike

"Ina Andersson" wrote:

After sorting a big table I need to find the duplicates that appears in a
special column? Do anybody know?