I'm tasked with establishing standard deviation values for a number of SKUS from historical weight data. I bring the weight data into excel in a column. I select the data, and then would like to have a macro that counts the number of data samples, breaks it into 10 roughly equal groups, performs min, max, stdev, count, and average functions to it, and then outputs it to a target location. This is more ambitious then I can code, and have been making due with this macro:
and manually doing everything else. Thanks a ton guys!
Bookmarks