Iterative Macro for cancelling out duplicate rows

[PickleRick]

Hi guys!

I'm trying to create an iterative macro that will compare each row against all the other rows to find a match with the negative Amount and Line Description but haven't been able to find a way to iterate each row individually so that it matches with only the first match and is then removed (the rows that do not have a match need to be filtered out).

Thanks in advance!

Example table:

Amount	Line Description
300	Fees
-750	Consulting advice
500	Accrual
750	Consulting advice
600	Journals
-500	Accrual
750	Consulting advice
-750	Consulting advice
-300	Fees

[T_Willins · Accepted solution]

Hi @PickleRick,

I think this does what you are looking for.  If this works, please mark as an accepted solution so the Community knows it has been solved!

[JosephSerpis]

Hi @PickleRick I mocked up an example on how to answer this. Let me know what you think?

[PickleRick]

Thank you @T_Willins, this worked wonders!

[PickleRick]

Thanks @JosephSerpis, I tried something similar but the only problem with this in my data set was that it caused too many duplicates in the join tool 

[benakesh]

Hi @PickleRick ,

This may not require iterative  macro  because   the macro can produce  results  with one iteration .  

Simple standard macro can be used if iterative macro runs once .

[PickleRick]

Thanks @Benakesh, I tried something similar but with the size of my data set and the amount of same Descriptions and Amounts I found using the join tool with a unique tool never gave me an accurate result 

[benakesh]

@PickleRick ,

To avoid duplicates sorting  may be required    on specific columns . Also  specific columns are selected in  unique  tool .