extract duplicat values

  • Thread starter adeel via OfficeKB.com
  • Start date
A

adeel via OfficeKB.com

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
 
Top