Related:
- Column comparation in different datasheet
- Comparing columns in two different excel sheets and if they match copying third column ✓ - Forum - Excel
- Compare three columns in excel and return a value ✓ - Forum - Excel
- Compare two columns in excel for partial matches - How-To - Excel
- Excel formula to compare two columns and return a value ✓ - Forum - Excel
- How to compare two columns in two different excel sheets using macro ✓ - Forum - Excel
1 reply
venkat1926
- Posts
- 1862
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- July 30, 2015
many ways of doing it. see are you happy with this
in sheet2 in B2 (row one is column headings in both sheets)
type this formula
=IF(ISERROR(A2=Sheet1!$A$2:$A$10),"NO","fYES")
while writing the formula take the cursor to sheet1 and draw it whole data range in column A so that
$A$2:$A$10
will be correct range.
convert these references to absolute ref
copy B2 down
easy way is
take the cursor to right bottom B2 when cursor changes into bold plus sigb
click that plus sign
now filter sheet according to column B criteria being "NO"
in the filtered data copy column A and paste it in sheet 3
in sheet2 in B2 (row one is column headings in both sheets)
type this formula
=IF(ISERROR(A2=Sheet1!$A$2:$A$10),"NO","fYES")
while writing the formula take the cursor to sheet1 and draw it whole data range in column A so that
$A$2:$A$10
will be correct range.
convert these references to absolute ref
copy B2 down
easy way is
take the cursor to right bottom B2 when cursor changes into bold plus sigb
click that plus sign
now filter sheet according to column B criteria being "NO"
in the filtered data copy column A and paste it in sheet 3
Report
Ruben
Thank you a lot! you solved my problem. Best regards!
