RE: $$Excel-Macros$$ LINEST

2011-07-23 Thread Rajan_Verma
glegroups.com] On Behalf Of marston.go...@allstardirectories.com Sent: Saturday, July 23, 2011 1:11 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ LINEST I'm trying to utilize a series of data to execute multiple Linests. I have 10 columns of data of equal length. The first 9 columns rep

$$Excel-Macros$$ LINEST

2011-07-23 Thread marston.go...@allstardirectories.com
I'm trying to utilize a series of data to execute multiple Linests. I have 10 columns of data of equal length. The first 9 columns represent 'x-value' candidates The 10th column represents 'y-value' I'd like to create linests that utilize each potential unique variation of each of the first 9 col

$$Excel-Macros$$ Linest on non-contiguous arrays

2011-07-23 Thread marston.go...@allstardirectories.com
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 candi