Hello,
I'm sure this is relatively easy - however I'm looking to match two columns; A and B, once matched, I'd like to separate the Data attached to column B away from A. I.e. I'd like to separate Column A 750005 - to 750005 in column B (along with Column C and D data of 'L' and 'T'). I thought this would be a match function, followed with deleting the associated data that doesn't match. Unfortunately I can't figure out how to match and separate the data. Thanks in advance for any help, questions or queries i'll do my best to better explain.
The Columns Have numbers like so:
A B C D
750001 750002 T P
750005 750003 W M
750008 750004 L K
750009 750005 L T
750011 750008 H W
750012 750009 T D
750015 750010 E F
750016 750011 R P
750019 750012 G P
750020 750013 C A
Configuration: Windows XP Firefox 3.0.9
2 excel files and need to copy data from one to the other Compare 2 excel files Compare 2 excel sheets Excel spreadsheet data validation whole number visual basic.net Excel spreadsheet formulas Excel spreadsheet to tom tom 720 Excel vba match 2 ranges and sort in same order Free combo box excel spreadsheet How can i check for a number in an excel spreadsheet How to copy the total rows in an excel spreadsheet How to match 2 value in excel Inserting browser in excel spreadsheet Match 2 excel columns Match 2 sets of exel data Merge excel spreadsheet with access database Ntroduction of excel spreadsheet Referencing excel spreadsheet in word macro Sort data starting excel