repetition cases

[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.

 

[Guest]

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

 

[Gord Dibben]

Omar

Do you want just a unique list of patients?

Data>Filter>Advanced Filter.

Check "unique records" and your choice of where to put them.

For more on this method see Debra's site.

http://www.contextures.on.ca/xladvfilter01.html


Gord Dibben MS Excel MVP