Search : in
By :

How to sort and match two excel spreadsheets

Snowstorm, on Apr 27, 2009 5:32:46 am BST 
 Report this message to moderators

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

Best answers for « How to sort and match two excel spreadsheets » in :
How to compare 2 excel sheet and combine uniq data? ShowHow to compare 2 excel sheet and combine uniq data? Issue Solution Note Issue I have 2 excel sheets , A and B. There are redundant data in both sheets as well as uniq. All i want is to combine both with no redundant records. (A+B...
Import contacts from Excel to Outlook ShowImport contacts from Excel to Outlook Issue Solution Issue How to import a contact list from Excel to Outlook and having them in a single list of contact , and not as splited items? Solution By using the software Excel 2000 and...
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
Download ABC Amber Excel Converter ShowDo you know that your Excel spreadsheet can be converted into any format? Only ABC Amber Excel Converter can gather these many conversions into a single application. ABC Amber Excel Converter is a program to convert your XLS files into several...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
Introduction to Spreadsheet Concepts ShowWhat is a Spreadsheet? A spreadsheet (or spreadsheet program) is software that permits numerical data to be used and to perform automatic calculations on numbers contained in a table. It is also possible to automate complex calculations by using a...
Spreadsheets - The Excel Interface ShowExcel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...