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 readingCheck this article @ MS’s website to know where to get help for VBA programming. List of resources that are available to help you learn Visual Basic for Applications programming
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 readingTo flip the given row as shown in this figure, use the following macro Result row You can use the same macro for flipping columns too, code will find if it’s a row or a column. Note: This code was modified on 07/26/07 for error checking, and removal of Option Base Sub flip() Dim Arr […]
Continue reading