hi!

i am having a list of values thru A1:A10
as under:


10.1
3.2
1.4
2.0
4.0
5.5
3.0
0.5
1.1
0.5

what i want is to retain the rows A4 and A9 alone, after offsetting

A2+A3+A6 against A1 (10.1)

and

A7+A8+A10 against A5 (4.0)


hlp pl?

-via135


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

I don't understand what you want to do. Please re-post with a clearer
description (plus example) of what it is you want to achieve.

Pete

via135 wrote:
hi!

i am having a list of values thru A1:A10
as under:


10.1
3.2
1.4
2.0
4.0
5.5
3.0
0.5
1.1
0.5

what i want is to retain the rows A4 and A9 alone, after offsetting

A2+A3+A6 against A1 (10.1)

and

A7+A8+A10 against A5 (4.0)


hlp pl?

-via135


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

hi Pete!

the purpose is for reconciliation of entries.

if i make it clear

COL "A" ....COL "B"

10.1.........D
3.2 .........C
1.4..........C
2.0..........C
4.0..........D
5.5..........C
3.0..........C
0.5..........C
1.1..........D
0.5..........C

where "D" for Debit "C" for Credit. I want to extract the unreconciled
entries in COL A (either Debit or Credit). The total of credits in
A2,A3 and A6 (3.2+1.4+5.5) equals the debit in A1 (10.1). Like the
sameway the credits in A7,A8 and A10 ( 3+0.5+0.5) equals the debit in
A5 (4.0).

now the remaining unmatched entries are in

2.0......C------in A4
1.1......D------in A9

which is the result i want to achieve..!!!

am i clearer now?

-via135


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

reminding for help!!!

-via135





via135 Wrote:
hi Pete!

the purpose is for reconciliation of entries.

if i make it clear

COL "A" ....COL "B"

10.1.........D
3.2 .........C
1.4..........C
2.0..........C
4.0..........D
5.5..........C
3.0..........C
0.5..........C
1.1..........D
0.5..........C

where "D" for Debit "C" for Credit. I want to extract the unreconciled
entries in COL A (either Debit or Credit). The total of credits in
A2,A3 and A6 (3.2+1.4+5.5) equals the debit in A1 (10.1). Like the
sameway the credits in A7,A8 and A10 ( 3+0.5+0.5) equals the debit in
A5 (4.0).

now the remaining unmatched entries are in

2.0......C------in A4
1.1......D------in A9

which is the result i want to achieve..!!!

am i clearer now?

-via135


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

reminding again for help

-via135

via135 Wrote:
reminding for help!!!

-via135


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

reminding again & again for help???!!!

-via135

via135 Wrote:
reminding again for help

-via135


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