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 C1:D1, 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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Johnny B" wrote:
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