I have a series of columns that represent candidates 'x' values for a regression. I'd like to be able to create a very simple way of running linest scenarios on each independent permutation w/o having to rearrange all of the columns a bunch of different times.
Example: Column A-J are the candidate X values, Column K is the Y value. Scenario 1: Column A,B,C,D,E,F,G,H,I,J Scenario 2: Column A,B,C,D,E,F,G,H,I Scenario 3: Column A,B,C,D,E,F,G,H,J etc. I'd be storing values out of the LINEST to provide R-square, Coefficients, and calc T-stats But I need a method to select non-contiguous columns to make this work. Thoughts? -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel