| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Duplicates
my data is on two different sheets in one workbook (sheet1-A1:A200 and
sheet2- A1:A1096) . would like to compare the two columns for duplicates and extract to a new sheet or higlight duplicates in order for further detailed analysis. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Duplicates
Visit Chip at www.cpearson.com . He has lots of stuff on duplicates
best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "wynand" wrote in message ... my data is on two different sheets in one workbook (sheet1-A1:A200 and sheet2- A1:A1096) . would like to compare the two columns for duplicates and extract to a new sheet or higlight duplicates in order for further detailed analysis. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Duplicates
thank you
have tried "Extracting Elements Common To Two Lists" on the site, but my columns have different number of rows, so haven't suceeded yet. "Bernard Liengme" wrote: Visit Chip at www.cpearson.com . He has lots of stuff on duplicates best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "wynand" wrote in message ... my data is on two different sheets in one workbook (sheet1-A1:A200 and sheet2- A1:A1096) . would like to compare the two columns for duplicates and extract to a new sheet or higlight duplicates in order for further detailed analysis. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Duplicates in excel that aren't 100% DUPLICATES ... | Excel Discussion (Misc queries) | |||
| Duplicates | Excel Discussion (Misc queries) | |||
| Duplicates - not all the same | Excel Discussion (Misc queries) | |||
| duplicates | Excel Discussion (Misc queries) | |||
| Duplicates? | Excel Discussion (Misc queries) | |||
Hybrid Mode
