Compare rows

You could use Evaluate to conduct a calculation, ie

Please Login or Register  to view this content.

It's not really clear what your end goal is but the above is meant purely as an illustration of a potential approach (avoiding iteration)

I have a macro that merge different files into one, the problem is that i get alot of duplicate rows. So i thought the easiest way to get rid of them is to sort the list by the ID column and then compare row i with i-1 with a loop, if they are the same delete them. The problem is that i can't compare the rows.

I don't fully understand the code you gave me but i will try it and see if i can figure out how to use it with my problem. Does it work with names and stuff as data, or only with numbers ?

This is a pretty big change from the initial question... and in truth the requirements remain vague - are you testing combination of A & B ?

Assuming the data was sorted as implied and that you are looking for combinations of A & B then you could use something like:

Please Login or Register  to view this content.