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

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