Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
matching cells
I have three columns that containt text (100's of names) and I need to
match one column to the next to see where duplicates may be. What is the best way to do this? Thanks!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
matching cells
Assuming data start in A1 and occupy three columns.
Insert two columns between A:A and B:B. Next to A1 enter the formula: =COUNTIF(D:E, A1)<1 and copy down. Apply Data|Filter|AutoFilter and select the rows that display TRUE in B:B. Select and erase those data. Delete the inserted columns B:C. Repeat the process between original columns B:C. Use in C1: =COUNTIF(F:F, B1)<1 At the end of the second round all three columns will contain globally unique data. COpy and paste in a single column if desired (recommended). HTH Kostis Vezerides |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
matching cells
Thank you so much for your help
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make multiple cells in 1 worksheet equal multiple cells in another | Excel Worksheet Functions | |||
requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
Matching cells | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |