Flag if Duplicate

**LottieCampbell** · 03-29-2012, 09:38 AM

Hi,

I have one column of data in excel, and I need excel to mark (in the adjacent column) if the contents of that cell appears anywhere else in that column. In my data I have a list of reference numbers for items, and I need to know if any item has more that one reference number .
Can any one help ?

Thanks

**tom1977** · 03-29-2012, 09:43 AM

Hi

look into attachment and try type numbers in column A

**Søren Larsen** · 03-29-2012, 09:44 AM

Try using =FIND(), and search in the column. If it returns a value larger than 1, then it's a duplicate. You can use an =IF() statement around the =FIND() statement, to get the "flag" you want returned.