Data matching

F

Fuzzy

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top