offsetting values of multiple cells!

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

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

reminding for help!!!

-via135

Originally Posted by via135

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

reminding again for help

-via135

Originally Posted by via135

reminding for help!!!

-via135

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

-via135

Originally Posted by via135

reminding again for help

-via135

is it so tough???

-via135

Originally Posted by via135

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

-via135

Hello via,

I'm sorry - I've only just noticed that you have been repeatedly asking
for help.

I know from other similar postings that this can be very difficult to
achieve, and the fact that nobody else has picked up your pleas for
help is indicative of this. However, I like a challenge, so I will look
into this. First a few questions:

How representative is your example data? Are you likely to have only 10
payments, or could there be many more to reconcile?

How frequently would you want to carry out the reconciliation?

Are you likely to have only one debit and one credit unmatched, as in
your example, or could there in reality be many of each that are
unmatched?

I can't do anything more at the moment - it's 3am here now and I need
some sleep. Also, I rarely check the newsgroups at weekends, so it may
be next week before I check for your response.

Hope this helps for the moment.

Pete

via135 wrote:
> is it so tough???
>
> -via135
>
>
> via135 Wrote:
> > reminding again & 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

hi Pete!

no problem!
actually i have to reconcile more than 1000s of entries on weekly basis!
outof which nearly 75% will be of one to one type which i can easily eliminate from the list!

for the remaining 25% i need some solution for reconciliation!

there may be atleast 2 or more credits which equals a single debit entry and vice versa.!!

if you want more expl i am ready to provide!

regds!

-via135

Originally Posted by Pete_UK

Hello via,

I'm sorry - I've only just noticed that you have been repeatedly asking
for help.

I know from other similar postings that this can be very difficult to
achieve, and the fact that nobody else has picked up your pleas for
help is indicative of this. However, I like a challenge, so I will look
into this. First a few questions:

How representative is your example data? Are you likely to have only 10
payments, or could there be many more to reconcile?

How frequently would you want to carry out the reconciliation?

Are you likely to have only one debit and one credit unmatched, as in
your example, or could there in reality be many of each that are
unmatched?

I can't do anything more at the moment - it's 3am here now and I need
some sleep. Also, I rarely check the newsgroups at weekends, so it may
be next week before I check for your response.

Hope this helps for the moment.

Pete

via135 wrote:
> is it so tough???
>
> -via135
>
>
> via135 Wrote:
> > reminding again & 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

One possible formulas play as per response
to your later posting in this group on the same subject, re:
http://tinyurl.com/mynj4
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---