| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding duplicates within a column
I am looking for duplicates within column A and in column B I want it to say
the duplicates and then the non-duplicates I want to be blank. Column A Column B Fish Fish Dog Rabbit Rabbit Fish Rabbit |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Finding duplicates within a column
see reply to your earlier posting
-- Regards Roger Govier "Cynthia Amrit" <Cynthia wrote in message ... I am looking for duplicates within column A and in column B I want it to say the duplicates and then the non-duplicates I want to be blank. Column A Column B Fish Fish Dog Rabbit Rabbit Fish Rabbit |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Finding duplicates within a column
Hi Cynthia,
There is option. Go to Column C and type =EXACT(A1:A5,B1:B5) It will return the following results. A B C 1 Fish Fish True 2 Dog 3 Rabbit Rabbit 4 Fish 5 Rabbit Copy the content in C1 and paste it in the rest of the cells (C2 to C5) The result will be shown as follows in Column C C 1. True 2. False 3. True 4. False 5. False All the results that are "True" are Duplicates. -- SAWTHEYA SAWTHEYA SAWTHEYA SAWTHEYA SAWTHEYA SAWTHEYA "Cynthia Amrit" wrote: I am looking for duplicates within column A and in column B I want it to say the duplicates and then the non-duplicates I want to be blank. Column A Column B Fish Fish Dog Rabbit Rabbit Fish Rabbit |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding duplicates within a column | Excel Discussion (Misc queries) | |||
| Finding Duplicates in a Column (Without Sorting) | Excel Discussion (Misc queries) | |||
| Finding Duplicates | Excel Worksheet Functions | |||
| Finding and Deleting duplicates in a column | Excel Worksheet Functions | |||
| Finding Duplicates and somehow flagging them in another column | Excel Discussion (Misc queries) | |||
Linear Mode
