Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 -- via135 ------------------------------------------------------------------------ via135's Profile: http://www.excelforum.com/member.php...o&userid=26725 View this thread: http://www.excelforum.com/showthread...hreadid=548681 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
offsetting values of multiple cells!
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
offsetting values of multiple cells!
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
offsetting values of multiple cells!
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
offsetting values of multiple cells!
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
offsetting values of multiple cells!
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
offsetting values of multiple cells!
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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
offsetting values of multiple cells!
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 |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
offsetting values of multiple cells!
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 Pete_UK Wrote: 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 -- via135 ------------------------------------------------------------------------ via135's Profile: http://www.excelforum.com/member.php...o&userid=26725 View this thread: http://www.excelforum.com/showthread...hreadid=548681 |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
offsetting values of multiple cells!
One possible formulas play as per response
to your later posting in this group on the same subject, http://tinyurl.com/mynj4 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i ignore blank cells when multiple cells? | Excel Worksheet Functions | |||
Adding separate accumulators for multiple cells | New Users to Excel | |||
How can I have excel search and add multiple cells to find a targe | Excel Discussion (Misc queries) | |||
Values for Y and N in multiple cells | Excel Discussion (Misc queries) | |||
Adding multiple cells, return specific values | Excel Worksheet Functions |