is this even possible?
in [General]
|
Prev: Excel file slow
Next: excell
From: Bowmanator on 15 Mar 2010 23:53 John, that's almost right on except is it possible for column D to show what is to make up the 1,000? example would be that i have 999 left over from 3/15 so on 3/16 i'd start out with 999 in column C and column D should show that i need 1 from 3/16 to equal 1,000 thanks "John" wrote: > Hi Bowmanator > I've attached a link to a sample file. Download it and check if that's what you > want. > http://cjoint.com/?dprqqVSBia > Take note of its limitation. > HTH > John > "Bowmanator" <Bowmanator(a)discussions.microsoft.com> wrote in message > news:66821ED8-2133-4A80-B286-702D0F01558B(a)microsoft.com... > > i'm working on a shipping log that i do now by hand and would like to > > automate if possible. every load equals 1,000 and alot of the loads are split > > loads. > > > > a b c d e > > 1 date amount previous current total > > 2 3/10 2053 1000 > > 3 1000 > > 4 53 > > 5 3/11 1019 53 947 1000 > > 6 72 > > 7 3/12 3000 72 928 1000 > > 8 1000 > > 9 1000 > > 10 72 > > > > in this example it shows what i need to equal 1,000 and if there's over > > 1,000 left of that run i'd like the next line to show 1,000 and so on until i > > can't make a full load of 1,000. > > > > hope this sounds right > > thanks > > . >
From: John on 16 Mar 2010 08:20 Hi Bowmanator Try this one, I changed the formula in column C to accommodate the 0 value in the Balance column. I think this is what you want in Column D. http://cjoint.com/?dprqqVSBia HTH John "Bowmanator" <Bowmanator(a)discussions.microsoft.com> wrote in message news:910EFD52-BAF1-4D49-AA48-447F24DF7C35(a)microsoft.com... > John, that's almost right on except is it possible for column D to show what > is to make up the 1,000? > > example would be that i have 999 left over from 3/15 so on 3/16 i'd start > out with 999 in column C and column D should show that i need 1 from 3/16 to > equal 1,000 > > thanks > > "John" wrote: > >> Hi Bowmanator >> I've attached a link to a sample file. Download it and check if that's what >> you >> want. >> http://cjoint.com/?dprqqVSBia >> Take note of its limitation. >> HTH >> John >> "Bowmanator" <Bowmanator(a)discussions.microsoft.com> wrote in message >> news:66821ED8-2133-4A80-B286-702D0F01558B(a)microsoft.com... >> > i'm working on a shipping log that i do now by hand and would like to >> > automate if possible. every load equals 1,000 and alot of the loads are >> > split >> > loads. >> > >> > a b c d e >> > 1 date amount previous current total >> > 2 3/10 2053 1000 >> > 3 1000 >> > 4 53 >> > 5 3/11 1019 53 947 1000 >> > 6 72 >> > 7 3/12 3000 72 928 1000 >> > 8 1000 >> > 9 1000 >> > 10 72 >> > >> > in this example it shows what i need to equal 1,000 and if there's over >> > 1,000 left of that run i'd like the next line to show 1,000 and so on until >> > i >> > can't make a full load of 1,000. >> > >> > hope this sounds right >> > thanks >> >> . >>
From: John on 16 Mar 2010 08:35 I sent you the wrong link, try this one: http://cjoint.com/?dqnlFNldPq John "John" <johnd(a)newlook.com> wrote in message news:%231fw2MQxKHA.3896(a)TK2MSFTNGP02.phx.gbl... > Hi Bowmanator > > Try this one, I changed the formula in column C to accommodate the 0 value in > the Balance column. > I think this is what you want in Column D. > http://cjoint.com/?dprqqVSBia > > HTH > John > > "Bowmanator" <Bowmanator(a)discussions.microsoft.com> wrote in message > news:910EFD52-BAF1-4D49-AA48-447F24DF7C35(a)microsoft.com... >> John, that's almost right on except is it possible for column D to show what >> is to make up the 1,000? >> >> example would be that i have 999 left over from 3/15 so on 3/16 i'd start >> out with 999 in column C and column D should show that i need 1 from 3/16 to >> equal 1,000 >> >> thanks >> >> "John" wrote: >> >>> Hi Bowmanator >>> I've attached a link to a sample file. Download it and check if that's what >>> you >>> want. >>> http://cjoint.com/?dprqqVSBia >>> Take note of its limitation. >>> HTH >>> John >>> "Bowmanator" <Bowmanator(a)discussions.microsoft.com> wrote in message >>> news:66821ED8-2133-4A80-B286-702D0F01558B(a)microsoft.com... >>> > i'm working on a shipping log that i do now by hand and would like to >>> > automate if possible. every load equals 1,000 and alot of the loads are >>> > split >>> > loads. >>> > >>> > a b c d e >>> > 1 date amount previous current total >>> > 2 3/10 2053 1000 >>> > 3 1000 >>> > 4 53 >>> > 5 3/11 1019 53 947 1000 >>> > 6 72 >>> > 7 3/12 3000 72 928 1000 >>> > 8 1000 >>> > 9 1000 >>> > 10 72 >>> > >>> > in this example it shows what i need to equal 1,000 and if there's over >>> > 1,000 left of that run i'd like the next line to show 1,000 and so on >>> > until i >>> > can't make a full load of 1,000. >>> > >>> > hope this sounds right >>> > thanks >>> >>> . >>> >
From: Bowmanator on 16 Mar 2010 10:16 John, that's exactly what i'm looking for, i just have 1 question though. don't know if i'll explain it right but i'll give it a try. the formulas work great except when the results are more then two. example, in the attachment you sent the leftover from C14 and F14 transfered down to C18 like it should, but since there is more than 1 result under the 3/18/2010 entry the final result C21 and F21 dosen't transfer, but if the final balance ended at C19 it will transfer down. hope it doesn't sound to confussing. thanks "John" wrote: > I sent you the wrong link, try this one: > http://cjoint.com/?dqnlFNldPq > John > "John" <johnd(a)newlook.com> wrote in message > news:%231fw2MQxKHA.3896(a)TK2MSFTNGP02.phx.gbl... > > Hi Bowmanator > > > > Try this one, I changed the formula in column C to accommodate the 0 value in > > the Balance column. > > I think this is what you want in Column D. > > http://cjoint.com/?dprqqVSBia > > > > HTH > > John > > > > "Bowmanator" <Bowmanator(a)discussions.microsoft.com> wrote in message > > news:910EFD52-BAF1-4D49-AA48-447F24DF7C35(a)microsoft.com... > >> John, that's almost right on except is it possible for column D to show what > >> is to make up the 1,000? > >> > >> example would be that i have 999 left over from 3/15 so on 3/16 i'd start > >> out with 999 in column C and column D should show that i need 1 from 3/16 to > >> equal 1,000 > >> > >> thanks > >> > >> "John" wrote: > >> > >>> Hi Bowmanator > >>> I've attached a link to a sample file. Download it and check if that's what > >>> you > >>> want. > >>> http://cjoint.com/?dprqqVSBia > >>> Take note of its limitation. > >>> HTH > >>> John > >>> "Bowmanator" <Bowmanator(a)discussions.microsoft.com> wrote in message > >>> news:66821ED8-2133-4A80-B286-702D0F01558B(a)microsoft.com... > >>> > i'm working on a shipping log that i do now by hand and would like to > >>> > automate if possible. every load equals 1,000 and alot of the loads are > >>> > split > >>> > loads. > >>> > > >>> > a b c d e > >>> > 1 date amount previous current total > >>> > 2 3/10 2053 1000 > >>> > 3 1000 > >>> > 4 53 > >>> > 5 3/11 1019 53 947 1000 > >>> > 6 72 > >>> > 7 3/12 3000 72 928 1000 > >>> > 8 1000 > >>> > 9 1000 > >>> > 10 72 > >>> > > >>> > in this example it shows what i need to equal 1,000 and if there's over > >>> > 1,000 left of that run i'd like the next line to show 1,000 and so on > >>> > until i > >>> > can't make a full load of 1,000. > >>> > > >>> > hope this sounds right > >>> > thanks > >>> > >>> . > >>> > > > > . >
From: John on 16 Mar 2010 11:18
Hi You're right, a "bug", the formula I used in column C is no good for this application. I need to rethink this over, don't know if I've got time today. Did you look the macro that Otto Moehrbach sent you, it works very well from what I can see. Anyway, I will have a look and see if I can correct the problem. It's the "MIN() formula in the other cells that is giving me the problem, I may need to rethink and start new. Will post back. Regards John "Bowmanator" <Bowmanator(a)discussions.microsoft.com> wrote in message news:FC809595-BCF0-4B5F-8FF6-8C04EEFE3549(a)microsoft.com... > John, > > that's exactly what i'm looking for, i just have 1 question though. > > don't know if i'll explain it right but i'll give it a try. > > the formulas work great except when the results are more then two. > > example, in the attachment you sent the leftover from C14 and F14 > transfered down to C18 like it should, but since there is more than > 1 result under the 3/18/2010 entry the final result C21 and F21 > dosen't transfer, but if the final balance ended at C19 it will transfer down. > > hope it doesn't sound to confussing. > > thanks > > "John" wrote: > >> I sent you the wrong link, try this one: >> http://cjoint.com/?dqnlFNldPq >> John >> "John" <johnd(a)newlook.com> wrote in message >> news:%231fw2MQxKHA.3896(a)TK2MSFTNGP02.phx.gbl... >> > Hi Bowmanator >> > >> > Try this one, I changed the formula in column C to accommodate the 0 value >> > in >> > the Balance column. >> > I think this is what you want in Column D. >> > http://cjoint.com/?dprqqVSBia >> > >> > HTH >> > John >> > >> > "Bowmanator" <Bowmanator(a)discussions.microsoft.com> wrote in message >> > news:910EFD52-BAF1-4D49-AA48-447F24DF7C35(a)microsoft.com... >> >> John, that's almost right on except is it possible for column D to show >> >> what >> >> is to make up the 1,000? >> >> >> >> example would be that i have 999 left over from 3/15 so on 3/16 i'd start >> >> out with 999 in column C and column D should show that i need 1 from 3/16 >> >> to >> >> equal 1,000 >> >> >> >> thanks >> >> >> >> "John" wrote: >> >> >> >>> Hi Bowmanator >> >>> I've attached a link to a sample file. Download it and check if that's >> >>> what >> >>> you >> >>> want. >> >>> http://cjoint.com/?dprqqVSBia >> >>> Take note of its limitation. >> >>> HTH >> >>> John >> >>> "Bowmanator" <Bowmanator(a)discussions.microsoft.com> wrote in message >> >>> news:66821ED8-2133-4A80-B286-702D0F01558B(a)microsoft.com... >> >>> > i'm working on a shipping log that i do now by hand and would like to >> >>> > automate if possible. every load equals 1,000 and alot of the loads are >> >>> > split >> >>> > loads. >> >>> > >> >>> > a b c d e >> >>> > 1 date amount previous current total >> >>> > 2 3/10 2053 1000 >> >>> > 3 >> >>> > 1000 >> >>> > 4 >> >>> > 53 >> >>> > 5 3/11 1019 53 947 1000 >> >>> > 6 72 >> >>> > 7 3/12 3000 72 928 1000 >> >>> > 8 >> >>> > 1000 >> >>> > 9 >> >>> > 1000 >> >>> > 10 72 >> >>> > >> >>> > in this example it shows what i need to equal 1,000 and if there's over >> >>> > 1,000 left of that run i'd like the next line to show 1,000 and so on >> >>> > until i >> >>> > can't make a full load of 1,000. >> >>> > >> >>> > hope this sounds right >> >>> > thanks >> >>> >> >>> . >> >>> >> > >> >> . >> |