if Debit amounts are in Col A and Credit amounts are in Col B, you can
find out the outstanding Balance in Col C in following way.
Col A........Col B........Col C
Debit.......Credit.......Balance

amount....blank.......=C2+A3-B3

copy this function down in Col C
this format will ascertain outstanding amount in total not by
individual entries.

so far as filtering is concerned i dont think this can be done through
filtering.


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=535072