| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
extract duplicat values
i have large amount of data in two sheets with many rows and columns. now I
want a formula which could extract duplicat values (matching sheet 1 & sheet 2) and returne the result in sheet 3. the formula check values from columns A (first column) of both sheet 1 & sheet 2. Similary i need a formula which could extract those values which are in sheet 1 but not in sheet 2. thanks -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200911/1 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
extract duplicat values
Chip has lots of stuff on duplicates at www.cpearson.com
best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "adeel via OfficeKB.com" <u32736@uwe wrote in message news:9eeb7b976bee4@uwe... i have large amount of data in two sheets with many rows and columns. now I want a formula which could extract duplicat values (matching sheet 1 & sheet 2) and returne the result in sheet 3. the formula check values from columns A (first column) of both sheet 1 & sheet 2. Similary i need a formula which could extract those values which are in sheet 1 but not in sheet 2. thanks -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200911/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count letter"B" in one column based on unique value among duplicat | Excel Worksheet Functions | |||
| Extract values off a chart??? | Charts and Charting in Excel | |||
| compare lists, extract new values | Excel Discussion (Misc queries) | |||
| Extract values from formulas | Excel Discussion (Misc queries) | |||
| Extract Unique Values, Then Extract Again to Remove Suffixes | Excel Discussion (Misc queries) | |||
Linear Mode
