Sort and count 10 cols.

Sunline

Well-known Member
Joined
Oct 6, 2007
Messages
701
Office Version
  1. 2016
Platform
  1. 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.
Excel Workbook
OPBXCADDDEDFDGDHDRDSDT
1ClassDistDist1Stakes1Marg5Marg4Marg3Marg2Marg1Fav3Fav2Fav1
2MDN 3YO16701200150000.84.60.83.40.42110
3OPN HCP11001150100003.81.81.80.94.4314
4OPN HCP2000110075001.91.41.41.21.3213
5OPN HCP22001200120001.51.43.31.92.91264
6OPN HCP1400140080001.31.41.82.38.3213
7Rating 65160012003000011.82.72.56.52.74211
8Rating 6512001200350000.90.85.65.65.6242
9Rating 6516001200120000.85.65.65.62.3421
10Rating 7511001200300006.52.72.22.213214
11Rating 752000120080003.64.64.577.4561
12Rating 8516001200150001.10.538.84.3175
13Rating 8512002200350004.75.43.93.93.9345
14Rating 852300115075002.53.89.49.41.2155
15Rating 8516001200100002.81.51.43.31.95126
16SPEC MDN20001200300004.60.83.40.40.41102
17SPEC MDN1500160070003.21.56.20.85.6722
Sheet1
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Forum statistics

Threads
1,225,149
Messages
6,183,187
Members
453,151
Latest member
Lizamaison

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top