Thread: Dupplicates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eva Eva is offline
external usenet poster
 
Posts: 197
Default Dupplicates

Hi
I have in column A the data. In column B I would like to set the formula
that check if there are dupplicates. I tried this =COUNTIF(B$1:B2,B2)=2 but
it doesn't show me the first item that has dupplicates. Do you know how to
solve this problem?
Thanks
--
Greatly appreciated
Eva