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?
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?