|
After you filter your races by distance, you need to create about 12 blank rows beneath your last entry FOR EACH DISTANCE. Then copy the COUNT and % info about 3-4 spaces below the last entry for each distance and then update the range for each of the 9 rows. You do this for just one column. After you check that your ranges represent what you want them to be, copy the entire column and paste it as far across the worksheet as you want. You will get summed info for many factors that you will not ultimately use, but just hide those columns.
Another thing, once you start to see usable patterns develop, DO NOT DELETE columns of data that you don't like. Keep them in, because as you add races to your data base they will go into those columns that are now hidden. Otherwise you will be getting data from the wrong column in your database which will nullify all your hard work to date.
What track(s) are you profiling?
|