View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ann ann is offline
external usenet poster
 
Posts: 210
Default find duplicates in list

i have a single column of data. how do i highlight the duplicates in the
list. i've tried conditional formatting and can't get the formula right.
some rows might be duplicated 4 times and others just 2. tia