comparing values in two columns

[sanjog]

hello folks,

I am caught up in solving a problem wherein there are two columns A and B and values there in

A B
1 1
2 2
3 3
4 4
9 5
10 6
11 13
15 15


As you can see there are certain numbers that are missing between column B and A. I want to know which of the numbers that are present in column B are missing in column A ...any handy calculation ?

Thanks in advance
S

 

[JoeMo]

hello folks,

I am caught up in solving a problem wherein there are two columns A and B and values there in

A B
1 1
2 2
3 3
4 4
9 5
10 6
11 13
15 15


As you can see there are certain numbers that are missing between column B and A. I want to know which of the numbers that are present in column B are missing in column A ...any handy calculation ?

Thanks in advance
S

Copy the formula in C1 down and expand the range in column A to cover all your data.

Excel Workbook
	A	B	C
1	1	1
2	2	2
3	3	3
4	4	4
5	9	5	Not in Col A
6	10	6	Not in Col A
7	11	13	Not in Col A
8	15	15
Sheet7

 

[sanjog]

Wav...it worked so cool

Thanks a ton!!

Copy the formula in C1 down and expand the range in column A to cover all your data.
Sheet7

*	A	B	C
*
*
*
*
Not in Col A
Not in Col A
Not in Col A
*

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:64px;"><col style="width:80px;"></colgroup><tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]

[TD="bgcolor: #cacaca, align: center"]5[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]5[/TD]

[TD="bgcolor: #cacaca, align: center"]6[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]6[/TD]

[TD="bgcolor: #cacaca, align: center"]7[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]13[/TD]

[TD="bgcolor: #cacaca, align: center"]8[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]15[/TD]

</tbody>

Spreadsheet Formulas

Cell Formula C1 =IF(ISNA(MATCH(B1,$A$1:$A$8,0)),"Not in Col A","") <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

 

[JoeMo]

Wav...it worked so cool

Thanks a ton!!

You are welcome - thanks for your reply.