Hi :-)
It's been 15 years since I have written any VB code - and i've never done VBA in Excel... using excel 2007.
I need to calculate statistical data for analysis - Min, Max, Mean, Mode, Median, SD...
I have just two columns that I need to use:
ColA = Action {Run, Jump, Play, Swim, ...} for example
ColB = Time Action Took {2.34, 1.24, 5.25, 2.53, ...} for example.
I created a pivot table for Min, Max, Mean. But when it comes to more complex numbers like Mode, Median, variance, angh not so much.
I need to write a macro that will dynamically find all of the 'Run' Actions in ColA and Calculate Median, Mode, variance, SDs-3, and then find all the 'Jump' and calculate, etc...
Data is generated daily and the number of each Action in ColA varies significantly and I have 45 days of data which need quick results so I don't have a lot of time to "play" ;-).
Help would be greatly appreciated!
Thanks!
Bookmarks