Finding Info from Column A and Removing it from Column B

[Guest]

Hey guys, i was wondering if there was a way to find information from "Column
A" and remove it from "Column B"

For Example

| Column A | Column B |
| 1 | 1 |
| 3 | 2 |
| 5 | 3 |
| 6 | 4 |
| 8 | 5 |
| 9 | 6 |

into

| 1 | |
| 3 | 2 |
| 5 | |
| 6 | 4 |
| 8 | |
| 9 | |

or somehow use a Column C to Identify the rows that repeat column A info in
Column B.

For example:?

| 1 | 1 | 1 |
| 3 | 2 | |
| 5 | 3 | 3 |
| 6 | 4 | |
| 8 | 5 | 5 |
| 9 | 6 | 6 |

THANKS!

johnny b

 

[Guest]

One way to get both result sets easily ..

Assume data in cols A and B, from row2 down

In C1:
=IF(ISNUMBER(MATCH(B2,A:A,0)),"",B2)

In D1:
=IF(ISNUMBER(MATCH(B2,A:A,0)),B2,"")

Select C11, copy down to last row of data in col B. Col C returns only
items in col B not found in col A (your 1st result set), while col D returns
the other way round, ie only items in col B found in col A (your 2nd result
set). Just copy either col C or D as desired, then overwrite the source col B
with a paste special as values.

 

[Guest]

Sorry, some typos in earlier response just detected:

C1, D1 should have read as C2, D2

(trust above was obvious <g>)

---