Formula to find top rated

Davebro

Board Regular
Joined
Feb 22, 2018
Messages
120
Office Version
  1. 2021
  2. 2016
Platform
  1. Windows
Trying to find the top rating from each different time (
12:15:00​
Ballintoy Harbour)
155​

155​
dailyreport-2020-08-14.xls
ABC
112:15:00Secret Handsheikh149
212:15:00Ancient Times104
312:15:00Arceus1
412:15:00Ballyconneely Bay1
512:15:00Camerily Joe87
612:15:00Danzart152
712:15:00Mr Lauda118
812:15:00Prospect1
912:15:00Able Love1
1012:15:00Ballintoy Harbour155
1112:45:00Carribean Queen1
1212:45:00Favourite Niece111
1312:45:00Gangster Girl90
1412:45:00International Lady1
1512:45:00Keeping Secrets135
1612:45:00Kingmania122
1712:45:00Kornflake1
1812:45:00Maeves Memory92
1912:45:00Meu Amor156
2012:45:00Midnight Poppy1
2112:45:00Stockingfiller1
2212:45:00Three Hat Day96
2312:45:00Waitingonanalibi1
2412:45:00Zahrisa128
2513:00:00Acclamadic2
2613:00:00Baron Wild1
2713:00:00Britzka0
2813:00:00Trusted Ally141
2913:00:00Kalu Pande2
3013:00:00Ramon Di Loria1
3113:00:00A Case Of You2
3213:00:00Iron Sheriff142
3313:00:00Let Me Pass1
3413:00:00Rich Law No Law113
3513:00:00The Last Knight141
3613:00:00A Taad Moody2
3713:00:00Notoriously Risky1
3813:00:00Charterhouse198
3913:00:00Feeling Tip Top2
4013:00:00Men Of Dreams2
4113:00:00Even Flow2
4213:00:00Allagar173
4313:00:00Stitch Pickings104
4413:00:00Knocknakilla94
4513:00:00Breagagh88
4613:15:00War Whisper150
4713:15:00Inexes141
4813:15:00Airglow128
4913:15:00Epeius150
5013:15:00Lucky Lucky Man119
5113:15:00Foreshore151
5213:15:00Dream Together135
5313:15:00Singe Anglais143
5413:15:00Yukon Mission142
5513:15:00Knightcap138
5613:15:00Round The Island116
5713:30:00Talacre174
5813:30:00Connla1
5913:30:00Nepali1
6013:30:00Rosscarbery (GER)1
6113:30:00Rugadh Realta1
6213:30:00Shahaada1
6313:30:00Shandra2
6413:30:00Ubuntu1
6513:40:00Elland Road Boy1
6613:40:00Haseef96
6713:40:00Red Walls0
6813:40:00Sands In Time1
6913:40:00Shem147
7013:40:00The Flying Ginger2
7113:45:00Mr Orange143
7213:45:00Penny Pot Lane100
7313:45:00Jordan Electrics144
7413:45:00Coastal Mist131
7513:45:00Electric Mistress179
7613:45:00What A Business131
7713:45:00Jungle Inthebungle132
7813:45:00Araifjan136
7913:45:00Lincoln Gamble151
8013:45:00Only Alone141
8113:45:00Castlehill Retreat113
8214:00:00Chief Little Hawk202
8314:00:00Eastern Voice180
8414:00:00Hyde Park Barracks153
8514:00:00Frenetic236
8614:00:00All Things Bright102
8714:00:00Blue Cabochon172
8814:00:00Moon In Her Eye148
8914:00:00Sweet Gardenia116
9014:00:00Tilia Cordata1
9114:10:00Hot Scoop182
9214:10:00London Palladium143
9314:10:00Sands Of Time155
9414:10:00Bergerac157
9514:10:00Gumdrop117
9614:10:00Merry Secret132
9714:10:00Cuban Breeze185
9814:20:00Star In The Making159
9914:20:00Oakenshield147
10014:20:00Abstemious152
10114:20:00Treble Treble132
10214:20:00Breath Of Joy185
10314:20:00Stone Soldier147
10414:20:00Phuket Power154
10514:20:00Many A Star173
10614:20:00Hurcle139
10714:20:00Melody King153
10814:20:00Benefit Street170
10914:20:00Custodian118
11014:20:00Auckland Lodge126
11114:30:00Aircraft Carrier119
11214:30:00Broad Street171
11314:30:00Giuseppe Garibaldi153
11414:30:00Master Of Reality223
11514:30:00Micro Manage159
11614:30:00Sea The Lion171
11714:30:00Maria Christina140
11814:30:00Search For A Song230
11914:30:00Delphi264
12014:30:00Monument Valley189
12114:40:00Spirit Of Sisra146
12214:40:00Chase The Dollar162
12314:40:00Calcutta Cup154
12414:40:00Topper Bill159
12514:40:00Scots Gold106
12614:50:00Burmese Waltz213
12714:50:00Natalies Joy149
12814:50:00Shades Of Blue242
12914:50:00Caspian Queen153
13014:50:00Crispina150
13114:50:00Exceptional212
13214:50:00Jouska179
13314:50:00Lambeth Walk213
13414:50:00Magical Journey192
13514:50:00Mountain Brave184
13614:50:00Stormy Girl176
13715:00:00Leo De Fury228
13815:00:00Numerian212
13915:00:00Rakan193
14015:00:00Sinawann267
14115:00:00Armory247
14215:00:00Degraves204
14315:00:00Helvic Dream196
Sheet1
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Forum statistics

Threads
1,214,935
Messages
6,122,337
Members
449,077
Latest member
Jocksteriom

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