I have the same issue as DACLEMEN. 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. 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!
"jetted" wrote:
Hi
Do you mean something like the attach document?
Thanks
Densi
+-------------------------------------------------------------------+
|Filename: Book5.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5086 |
+-------------------------------------------------------------------+
--
jetted
------------------------------------------------------------------------
jetted's Profile: http://www.excelforum.com/member.php...o&userid=17532
View this thread: http://www.excelforum.com/showthread...hreadid=564360