View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Johnny B[_2_] Johnny B[_2_] is offline
external usenet poster
 
Posts: 20
Default Finding Info from Column A and Removing it from Column B

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