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 |
Finding Info from Column A and Removing it from Column B
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 |
Finding Info from Column A and Removing it from Column B
Sorry, some typos in earlier response just detected:
C1, D1 should have read as C2, D2 (trust above was obvious <g) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
All times are GMT +1. The time now is 11:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com