Thread: Duplicates
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
klafert klafert is offline
external usenet poster
 
Posts: 127
Default Duplicates

Let me Clarify The Item may be listed several times. Possible 12 times.
Such as
Blue
Red
Blue
Yellow
Blue
Green
Blue

So I would need to know every time Blue shows up. My goal is to delete all
but one of the Items.

"klafert" wrote:

I trying to use a formula to find Duplicates Entries in a Single Column. I
tried some formulas I found it but they didn't work.