hi!

yes..your method gives me the exact results i want!!
thks!!

i've noticed the error only after reading your reply..!!
sorry..!! should be due to naked eye counting!!

BTW is there any way to match the same items
but in two columns,
say all DR items in COL A
and all CR items in COL B

-via135





Max Wrote:
Just to clarify that for the sample data posted in A1:B22,
believe your "summary" contains 2 errors

Lines:
2000 DR - 2 rec
2000 CR - 3 rec

3000 DR - 2 rec
3000 CR - 1 rec

should have read as:

2000 DR - 3 rec
2000 CR - 3 rec

3000 DR - 1 rec
3000 CR - 1 rec

Think the outstanding amounts, after cancellations,
returned by the formulas in col F are correct, viz.: -1000, -4000
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=561822