offsetting values of multiple cells!

V

via135

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?

-via13
 
P

Pete_UK

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
 
V

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
 
V

via135

reminding for help!!!

-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 unreconcile
entries in COL A (either Debit or Credit). The total of credits i
A2,A3 and A6 (3.2+1.4+5.5) equals the debit in A1 (10.1). Like th
sameway the credits in A7,A8 and A10 ( 3+0.5+0.5) equals the debit i
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?

-via13
Click to expand...
 
P

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
 
V

via135

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to use an formula to transpose a list(left) to be like the right? 2
Return next non-Blank Cell in a Column ? 4
Maximum Number of Blank Cells between Non Blank Cells in a Range 5
Generate a special numerical sequence in Excel 97 3
rotating list 2
Formula is 2
enter numbers in blank cells 2
Ignore blanks in multiplication formula 4

Top