Sunline
Well-known Member
- Joined
- Oct 6, 2007
- Messages
- 701
- Office Version
- 2016
- Platform
- Windows
Hello all,
I'm wanting to sort ascending cols O and P into each class and dist.
Once this is done then sort next col BX and count each
individual data and give answer in col DU.
Repeat process thru to col DT, giving 10 different cols of count answers.
I have 20,000 rows to sort.
There are over one hundred classes and hundreds of dist1, Stakes, Marges, Fav .
If this is possible I want only one answer for each count at the last row
entry as I will be filtering these and a count up to answer will not help.
Golly I hope this makes cense.
Thanks.
I'm wanting to sort ascending cols O and P into each class and dist.
Once this is done then sort next col BX and count each
individual data and give answer in col DU.
Repeat process thru to col DT, giving 10 different cols of count answers.
I have 20,000 rows to sort.
There are over one hundred classes and hundreds of dist1, Stakes, Marges, Fav .
If this is possible I want only one answer for each count at the last row
entry as I will be filtering these and a count up to answer will not help.
Golly I hope this makes cense.
Thanks.
Excel Workbook | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
O | P | BX | CA | DD | DE | DF | DG | DH | DR | DS | DT | |||
1 | Class | Dist | Dist1 | Stakes1 | Marg5 | Marg4 | Marg3 | Marg2 | Marg1 | Fav3 | Fav2 | Fav1 | ||
2 | MDN 3YO | 1670 | 1200 | 15000 | 0.8 | 4.6 | 0.8 | 3.4 | 0.4 | 2 | 1 | 10 | ||
3 | OPN HCP | 1100 | 1150 | 10000 | 3.8 | 1.8 | 1.8 | 0.9 | 4.4 | 3 | 1 | 4 | ||
4 | OPN HCP | 2000 | 1100 | 7500 | 1.9 | 1.4 | 1.4 | 1.2 | 1.3 | 2 | 1 | 3 | ||
5 | OPN HCP | 2200 | 1200 | 12000 | 1.5 | 1.4 | 3.3 | 1.9 | 2.9 | 12 | 6 | 4 | ||
6 | OPN HCP | 1400 | 1400 | 8000 | 1.3 | 1.4 | 1.8 | 2.3 | 8.3 | 2 | 1 | 3 | ||
7 | Rating 65 | 1600 | 1200 | 30000 | 11.8 | 2.7 | 2.5 | 6.5 | 2.7 | 4 | 2 | 11 | ||
8 | Rating 65 | 1200 | 1200 | 35000 | 0.9 | 0.8 | 5.6 | 5.6 | 5.6 | 2 | 4 | 2 | ||
9 | Rating 65 | 1600 | 1200 | 12000 | 0.8 | 5.6 | 5.6 | 5.6 | 2.3 | 4 | 2 | 1 | ||
10 | Rating 75 | 1100 | 1200 | 30000 | 6.5 | 2.7 | 2.2 | 2.2 | 1 | 3 | 2 | 14 | ||
11 | Rating 75 | 2000 | 1200 | 8000 | 3.6 | 4.6 | 4.5 | 7 | 7.4 | 5 | 6 | 1 | ||
12 | Rating 85 | 1600 | 1200 | 15000 | 1.1 | 0.5 | 3 | 8.8 | 4.3 | 1 | 7 | 5 | ||
13 | Rating 85 | 1200 | 2200 | 35000 | 4.7 | 5.4 | 3.9 | 3.9 | 3.9 | 3 | 4 | 5 | ||
14 | Rating 85 | 2300 | 1150 | 7500 | 2.5 | 3.8 | 9.4 | 9.4 | 1.2 | 1 | 5 | 5 | ||
15 | Rating 85 | 1600 | 1200 | 10000 | 2.8 | 1.5 | 1.4 | 3.3 | 1.9 | 5 | 12 | 6 | ||
16 | SPEC MDN | 2000 | 1200 | 30000 | 4.6 | 0.8 | 3.4 | 0.4 | 0.4 | 1 | 10 | 2 | ||
17 | SPEC MDN | 1500 | 1600 | 7000 | 3.2 | 1.5 | 6.2 | 0.8 | 5.6 | 7 | 2 | 2 | ||
Sheet1 |