See:

http://www.tushar-mehta.com/excel/te...ues/index.html
--
Gary''s Student - gsnu200803


"Kevin W" wrote:

I'd like to find an easy way to clear
amounts against eachother. For example, I may have a list of about 400
numbers ranging from $1.89 to $2,046,688.21, positive and negative.
Normally, many numbers (2 - 20) will clear against each other (sum up to
zero). I find myself
staring at the screen for hours. Is there a function in excel that will
randomly look for these clearing items? Any VBA possible? The link below
must be old because I cannot access it.

Thanks!