Trick to validate the numbers

[CassieL]

Hi everyone, I'm trying to matched up my funding and payment = 0. I have more than 60K data and I need some tricks to clean up the data faster, please help.

In the below table, I have row 1,2,7 sum up to 0, I have row 3 and 6 sump up to 0. etc... Please help

[TABLE="class: grid, width: 100"]
<tbody>[TR]
[TD]1/1[/TD]
[TD]1000[/TD]
[/TR]
[TR]
[TD]1/1[/TD]
[TD]-500[/TD]
[/TR]
[TR]
[TD]1/2[/TD]
[TD]2500[/TD]
[/TR]
[TR]
[TD]1/5[/TD]
[TD]2500[/TD]
[/TR]
[TR]
[TD]1/5[/TD]
[TD]1250[/TD]
[/TR]
[TR]
[TD]1/8[/TD]
[TD]-2500[/TD]
[/TR]
[TR]
[TD]1/15[/TD]
[TD]-500[/TD]
[/TR]
[TR]
[TD]1/18[/TD]
[TD]-1250[/TD]
[/TR]
[TR]
[TD]1/20[/TD]
[TD]-900[/TD]
[/TR]
[TR]
[TD]1/21[/TD]
[TD]-2500[/TD]
[/TR]
</tbody>[/TABLE]

 

[Timjan]

You will have to add another column with unique I.D's. in line with the the existing Data and then use those I.D's, to perform your index/match.

 

[CassieL]

Hi Timjan,

Thanks for giving the idea, can you show me example how identifier can do the work with using idex/match?

Thanks!