Column comparation in different datasheet
Solved/Closed
Related:
- Column comparation in different datasheet
- Vba find column by name ✓ - Excel Forum
- Auto serial number in excel based on another column ✓ - Excel Forum
- How to convert row to column in notepad++ ✓ - Excel Forum
- How to increment numbers when value changes in another column? - Excel Forum
- Sum column if another column equals ✓ - Excel Forum
1 reply
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
Mar 6, 2012 at 04:59 AM
Mar 6, 2012 at 04:59 AM
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
Mar 6, 2012 at 08:02 AM