| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to extract duplicated data from two seperate worksheets?
Ok,
Suppose I have 2 worksheets. Sheet 1 has 1000 lines of data spanning xNumber of columns. Sheet 2 has 500 lines of data, also spanning the same number of columns. An unknown number of identical lines of data appear on both sheets. How can I get to a point where I can build one worksheet that is a composite of both sheets - such that no identical line of data appears twice on the final sheet? Thanks in advance, Simon. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create chart with data from across seperate worksheets | Charts and Charting in Excel | |||
| Linking data from Rows to columns in seperate worksheets | Excel Worksheet Functions | |||
| HOW DO I IDENTIFY DATA THAT IS DUPLICATED IN TWO SEPERATE WORKSHEE | Excel Discussion (Misc queries) | |||
| Create single chart with data from seperate worksheets | Charts and Charting in Excel | |||
| How do I seperate data from a pivot into seperate worksheets? | Excel Discussion (Misc queries) | |||
Threaded Mode
