Tushar has a great tutorial on his website. It tells you a lot about regression, trendline and using them in VBA. Check it out! Trendline coefficients: “Trendline Coefficients and Regression Analysis”
Continue readingAlthough Excel’s Data Analysis Toolpak can generate good random numbers, I had to create these various functions to meet my specific needs. First: Generating Unique Random Numbers This function was modified from ozgrid’s RandLotto function, which returns a string of numbers without duplicates. This function will return an array of unique random integers that are […]
Continue reading
Problem In Excel, from time-to-time you may want to stack different columns of data into one column. For example, if cell A1 has the value of Bob, A2 has Jane, and B1 has Mary and B2 has Sue, you may want to collapse all the values from both A and B columns into one column. […]
Continue reading