| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PivotTable - Repetition of rows | Excel Discussion (Misc queries) | |||
| check for repetition of cell contents | Excel Worksheet Functions | |||
| statistical analysis / trend repetition | Excel Discussion (Misc queries) | |||
| How to find repetition of data in cells in a column? | Excel Discussion (Misc queries) | |||
| Matching 2 cases at once. | Excel Discussion (Misc queries) | |||
Linear Mode
