hi sir.. I need help in VBA or function to do this. I have 2 excel files. Both have 6 columns. Each column contains a number. 1 file may contain 1000 rows and the other has like 100+ rows... I want to do is I'd like to compare the original list which is file2 to file1 and count how many match numbers are there in each row outputing the # of match to a new workbook would do just great... i've been working for this project for 1 month already and haven't seen any solutions to it.. Hoping your the one who could help me... Thanks in advance.
EX of matching
file1
A1:F1 match with
file2
A1:F1 = output = 2 match
A2:F2 = output = 3 match
A3:F3 = output = 6 match
next
file1
A2:F2 match with
file2
A1:F1 = output = 3 match
A2:F2 = output = 1 match
A3:F3 = output = 4 match
and so on..
=COUNT(IF(B1:B100="A",IF(ISNUMBER(A1:A100),1)))
sorry if I make you confuse.. I'm not good at explaining.. but here it goes..
Yes i want to count how many times row1 of sheet1 matches each rows of sheet 2... output is: if row 1 of sheet1 found 3 match in row1 sheet 2... it will output 3... next output... row1 of sheet1 vs row2 sheet2... if found match 4.. it will output 4...
the algorithm is like this...
sheet1
A1:F1 vs
sheet2
A1:F1 = output = 2 match
A2:F2 = output = 3 match
A3:F3 = output = 6 match
...so on
next will be
sheet1
A2:F2 vs
sheet2
A1:F1 = output = 3 match
A2:F2 = output = 1 match
A3:F3 = output = 4 match
and so on..
you decide how would you display the output that would be easy for me to understand...thanks for your help... its is greatly appreciated....GOD SPEED