hi see file i sent, it gives better result..
let me know if i paste wrong data set in col A. I used same data for col A, b & c Cheers!! On Thu, Jun 5, 2014 at 12:33 PM, 'Sleek' via MS EXCEL AND VBA MACROS < excel-macros@googlegroups.com> wrote: > Sequence of events: first i pasted all my actual data on column A ,then i > set it aside whatever has been utilised, then run the macro on remaining > (remove blanks) , place aside the other data, whatever is left i then, > place it final part of table(or array?) > the macro is run twice but can as well be run thrice, i also used the > constants SET lowest first, set highest first then run the macro. > unfortunately, the trial & error method via observation & juggling around > worked better than macro, see workbook. > > > > On Saturday, May 31, 2014 12:11:22 PM UTC+3, Sleek wrote: > >> >> I need a minimum or zero difference, against the target totals i have set. >> i have 3 columns, juggle around with figures.there is no barrier to how >> many you can put in column but use only the figures i give you. I think >> maybe using a solver or goal-seek is in order. >> >> >> >> sleek12 >> I >> > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
