hi!

i am having a list as under in A1 : B8 with Col Headings
where A3,A7,A8,B2,B4B5, & B6 are blank cells:

debit credit
100 blank
blank 100
300 blank
400 blank
500 blank
blank 300
blank 200


what i want is to filter the list and findout the individual
debit and credit outstandings and the result should be as under:

debit credit
400 blank
500 blank
blank 200

help pl?!

-via135


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