repetition cases
 

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.

repetition cases
 

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

"Omar" wrote:

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.

repetition cases
 

Omar

Do you want just a unique list of patients?

DataFilterAdvanced 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

On 9 May 2007 00:26:55 -0700, Omar wrote:

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.