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