repetition cases

O

Omar

Dear Experts,
I have a column contain the name of patients (text format) some names
appears more than on time, how can I identify the repetition cases and
than deleted?
Thanks.
 
M

Mike H

Put this formula in a cell alonside the first name in your list. It's and
array formula so enter it with Ctrl+Shift+enter.

=IF(COUNTIF($A$1:A1,A1)=1,A1,"")

Drag the formula down the lenght of your list and duplicates will be ignored.

You will be left with blank cells where duplicates existed which you can
hide using filter.


Mike

Mike
 
Top