Forum Discussion
SUM TO ZERO
Dear Users, I have over 6000 data and i want to Match all amount that sums to zero or a set value without the try and error method which takes time and prone to errors, please how can i achieve t...
You're correct that the highlighted cells do sum to zero.
That raises at least a number of questions:
- How did you identify them? (Or was this just a made-up set where you simply changed the signs?)
- Presumably every number in those highlighted ranges (or the vast majority of them) has a matching number:
- do you want therefore to identify
- every pair that sums to zero,
- every set of four that sums to zero,
- every set of six that sums to zero,
- etc
- Or just the largest set (as you have in your sample)
- ?
- do you want therefore to identify
You need to become a lot clearer.....
and maybe you could describe the context you're working in here as well, so long as it's not confidential. Maybe there's a different way to meet the objective.
