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
Combine 2 excel sheets Compare two excel spreadsheets Copying info from one excel spreadsheet to another Excel link 2 cells' formats Excel match cell contents vba Excel spreadsheet display formular Formula excel spreadsheet Forza 3 excel spreadsheet How do you use information from one excel spreadsheet on another How to create a macro to search other excel spreadsheets How to filter an excel spreadsheet to their cooresponding names How to seperate numbers in excel when there are 2 rows in a single cell If between 2 dates then equals value, excel Macro print & sort for excel Match 2 columns against 2 columns and return value in excel Microsoft excel spreadsheet =login Problem with excel spreadsheet select 1 cell highlights more than 1 Upload excel spreadsheet into quickbooks