| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data matching
Please help me tally if the data in both sheets are the same.
Excel 1 ColA ColB ColC Col D 101 1 1-Jan-2009 10,000 101 2 1-Mar-2009 20,000 101 3 1-Dec-2009 10,000 101 4 1-Jan-2010 15,000 102 1 1-Jan-2009 10,000 102 2 1-Mar-2009 20,000 102 3 1-Dec-2009 10,000 102 4 1-Jan-2010 15,000 EXCEL 2 ColA ColB ColC Col D ColE ColF ColG ColH 101 1 1-Jan-2009 10,000 101 2 1-Mar-2009 20,000 102 1 1-Jan-2009 10,000 102 2 1-Mar-2009 30,000 ColI ColJ ColK Col L ColM ColN ColO ColP 101 3 1-Dec-2009 10,000 101 4 1-Jan-2010 15,000 102 3 1-Dec-2009 10,000 102 4 1-Jan-2010 15,000 I want to compare if all the column's data against each row in excel 1, is correct in the excel 2. Unfortunately, excel 2 is spread across different columns and not in rows.... How do i verify this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Matching a column of new data to existing larger data set. | Excel Worksheet Functions | |||
| Matching identical data using data only once in the matching proce | Excel Discussion (Misc queries) | |||
| Matching Data | Excel Discussion (Misc queries) | |||
| Can I merge data in 2 sheets matching rows of data by last name? | Excel Discussion (Misc queries) | |||
| Matching data and linking it to the matching cell | Links and Linking in Excel | |||
Hybrid Mode
