View Single Post
Old 10-27-2019, 08:58 AM   #12
Dorianmode
always learning
 
Dorianmode's Avatar
 
Join Date: Jul 2011
Location: Minneapolis / Rancho Santa Fe
Posts: 277
Here is an updated profile (thanks Bill V for the huge data file of races) with the data at the top and filters applied to every column so you can keep all your races in one file, and use as many filters as you want, or in whatever way you want. Filtered data in Excel can be tricky. I used the subtotal functionality to get the same percent results that Ted set up in the formulas for the profiles without filters, and did some testing. If you notice something is amiss, please let me know. Thanks.
Attached Files
File Type: xlsx Filterable profile with data at top Bill V data.xlsx (1.84 MB, 765 views)

Last edited by Dorianmode; 10-27-2019 at 09:01 AM.
Dorianmode is offline   Reply With Quote