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

What are you trying to filter? I don't see any pattern in the result
you've shown.

via135 wrote:
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




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

hi Debra!

the pattern is A2 (100) offsetted against B3 (100), A4 (300) against
B7
(300). Now the unmatched items are in rows 5,6 & 8. I want to filter
out those three records!

-via135


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

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

hi!

i am particular about individual datewise outstanding entries where the
dates are in COL "C". it's ok if there is any other way other than
filtering?

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

hi!

reminding for some help..??!!

-via135


via135 Wrote:
hi!

i am particular about individual datewise outstanding entries where the
dates are in COL "C". it's ok if there is any other way other than
filtering?

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