find top 50% of stores

Hi

I was wondering if anyone can help me with finding the top 50% of all stores with a schedule of 5HTS and if possible be individual DC

I am new to excel and wish to learn all about formulas, etc

If anyone can help with this I would be overjoyed


DC No Branch Schedule Yearly Total
2 233 PLYMOUTH 6HTS 11,048,913
2 193 WOOD GREEN 6HTS 10,966,146
1 95 LEE CIRCLE 6HTS 10,216,116
1 169 CRYSTAL PEAKS 6HTS 9,906,379
1 286 DERBY NEW 6HTS 8,272,728
2 376 EXETER 6HTS 8,241,443
1 173 CHELMSFORD 6HTS 8,199,611
1 256 BEAUMONT LEYS 6HTS 8,115,570
2 206 BEXLEY HEATH 6HTS 8,083,016
1 275 BULWELL (NEW) 6HTS 7,985,798
1 127 DARLINGTON 5HTS 7,906,262
1 106 BARNSLEY 6HTS 7,843,979
2 181 EPSOM 6HTS 7,827,746
2 361 ILFORD 6HTS 7,794,996
2 159 BURGESS HILL 6HTS 7,755,540
2 320 GILLINGHAM 6HTS 5,303,318
1 77 CROSSGATES 5HTS 5,296,356
2 180 NEATH 5HTS 5,292,874
2 236 WEMBLEY 5HTS 5,291,684
1 381 MANCHESTER 6HTS 5,290,423
1 177 WALLASEY 6HTS 5,281,992
1 176 ILKESTON 5HTS 5,239,610
2 297 TAUNTON 6HTS 5,231,250

Many Thanks

Maybe with an pivot table.

See the attached file.