Hi,
Here is my problem - I have 5 workbooks in a folder, each with 11
columns. Could anyone please help me with this - I want to take value
from C1, G1 & I1 and compare it with C2, G2 & I2 and down. If it finds
a match then I need to increment a counter. Once it goes through the
whole list, I need to do the same with the next not same row. I hope
the last part made sense. For example
Row C Row G Row I
1234 01 01
1234 01 01
1224 01 02
1244 01 03
1224 10 01
1234 01 01
1224 01 02

So it starts with first row goes through the whole list writes the
result as shown below, then looks at the 2nd row and since it is the
same as the first one, it should skip that row and go to the next one
(i.e., row 3) and start counting down
Result set should be

Row A Row B Row C Count
1234 01 01 3
1224 01 02 2
1244 01 03 1
1224 10 01 1

Need to write this result to the worksheet "data_from_files" in the
workbook "Combined". Need to do the same from all the 5 workbooks.
Each of the 5 workbook has only 1 sheet, but will have more than 30000
rows.

Any help on this would be greatly appreciated. Thanks in advance.