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
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	*

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:64px;"><col style="width:80px;"></colgroup><tbody>
</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.