Sorting 3 rows with Time.

emvella

Board Regular
Joined
Apr 7, 2017
Messages
68
Office Version
  1. 2013
Platform
  1. Windows
Hi,

Please how can I sort this page by the time? I cannot do it because time is every 3 rows.

22-JunSpain Primera División FemeninaBarcelona (w) have over 0.5 first half goals in their last 17 games.
14:00Athletic Club (w)
Barcelona (w)
22-JunBelarus CupBATE have over 0.5 first half goals in their last 12 games.
15:30Baranovichi
BATE
22-JunEcuador Supercopa de EcuadorLDU Quito have over 0.5 first half goals in their last 12 games.
22:00LDU Quito
Delfin
22-JunNorway 1. DivisionRaufoss have over 0.5 first half goals in their last 11 games.
16:00Ranheim
Raufoss
22-JunArgentina Prim B MetroJJ Urquiza have over 0.5 first half goals in their last 9 games.
18:10JJ Urquiza
Sacachispas
22-JunAustria TFV CupSwarovski Tirol II have over 0.5 first half goals in their last 9 games.
17:00Swarovski Tirol II
Fügen
22-JunWorld Club FriendliesSparta Praha have over 0.5 first half goals in their last 9 games.
15:30Sparta Praha
Sokol Hostouň
22-JunNorway ToppserienAvaldsnes (w) have over 0.5 first half goals in their last 9 games.
16:00Rosenborg (w)
Avaldsnes (w)
22-JunArgentina Primera NacionalTristán Suárez have over 0.5 first half goals in their last 8 games.
18:00Tristán Suárez
San Martín San Juan
22-JunBelarus CupOrsha have over 0.5 first half goals in their last 8 games.
16:00Orsha
Gomel
22-JunNorway ToppserienVålerenga (w) have over 0.5 first half goals in their last 8 games.
17:00Vålerenga (w)
Arna-Bjørnar (w)
22-JunWorld Club FriendliesŽilina have over 0.5 first half goals in their last 8 games.
21:00Lokomotiv Moscow
Žilina
22-JunBelarus CupBaranovichi have over 0.5 first half goals in their last 8 games.
15:30Baranovichi
BATE
22-JunArgentina Prim B MetroArgentino Quilmes have over 0.5 first half goals in their last 8 games.
18:30Argentino Quilmes
Acassuso
22-JunIceland 1. Deild WomenFH (w) have over 0.5 first half goals in their last 7 games.
0.80FH (w)
Grindavík (w)
22-JunWorld Club FriendliesSlovácko have over 0.5 first half goals in their last 7 games.
16:00Slovácko
Vyškov
22-JunBangladesh Premier LeagueAbahani have over 0.5 first half goals in their last 6 games.
11:00Abahani
Mohammedan Dhaka
22-JunIceland CupHaukar have over 0.5 first half goals in their last 6 games.
18:00KF
Haukar
22-JunUruguay Primera DivisiónLiverpool have over 0.5 first half goals in their last 6 games.
15:45Liverpool
Fénix
22-JunArgentina Prim B MetroFénix have over 0.5 first half goals in their last 6 games.
18:30Fénix
Deportivo Merlo
22-JunTanzania Ligi kuu BaraSimba have over 0.5 first half goals in their last 5 games.
13:00Simba
Mbeya City
22-JunSpain Primera División FemeninaAthletic Club (w) have over 0.5 first half goals in their last 5 games.
14:00Athletic Club (w)
Barcelona (w)
22-JunFinland YkkönenVPS have over 0.5 first half goals in their last 5 games.
15:30VPS
RoPS
22-JunRussia Supreme Division WomenRyazan (w) have over 0.5 first half goals in their last 5 games.
15:00Chertanovo (w)
Ryazan (w)
22-JunIceland 1. Deild WomenKR (w) have over 0.5 first half goals in their last 5 games.
19:15KR (w)
Afturelding (w)
22-JunBrazil Serie BConfiança have over 0.5 first half goals in their last 5 games.
19:30Confiança
Vila Nova
22-JunNorway ToppserienLillestrøm (w) have over 0.5 first half goals in their last 5 games.
13:00Klepp (w)
Lillestrøm (w)
22-JunBelarus CupSmorgon have over 0.5 first half goals in their last 5 games.
16:30Arsenal
Smorgon
22-JunJapan J1 LeagueConsadole Sapporo have over 0.5 first half goals in their last 5 games.
21:00Consadole Sapporo
Cerezo Osaka
22-JunArgentina Primera NacionalAtlético Rafaela have over 0.5 first half goals in their last 5 games.
18:30Barracas Central
Atlético Rafaela
22-JunArgentina Prim B MetroAcassuso have over 0.5 first half goals in their last 4 games.
18:30Argentino Quilmes
Acassuso
22-JunItaly Campionato Primavera 1Roma U19 have over 1.5 first half goals in their last 4 games.
17:00Roma U19
Atalanta U19
22-JunWorld Club FriendliesKrylya Sovetov have over 0.5 first half goals in their last 4 games.
16:00Spartak Subotica
Krylya Sovetov
22-JunEurope European ChampionshipCzech Republic have over 0.5 first half goals in their last 4 games.
19:00Czech Republic
England
22-JunPeru Copa BicentenarioSporting Cristal have over 0.5 first half goals in their last 4 games.
21:00Sporting Cristal
Ayacucho
22-JunUSA MLSOrlando City have over 0.5 first half goals in their last 4 games.
23:30Orlando City
SJ Earthquakes
22-JunUruguay Primera DivisiónFénix have over 0.5 first half goals in their last 4 games.
15:45Liverpool
Fénix
22-JunBelarus CupSlavia have over 0.5 first half goals in their last 4 games.
15:45Volna
Slavia
22-JunBelarus CupGomel have over 1.5 first half goals in their last 4 games.
16:00Orsha
Gomel
22-JunSpain Primera División FemeninaAthletic Club (w) have over 1.5 first half goals in their last 4 games.
14:00Athletic Club (w)
Barcelona (w)
22-JunBrazil Serie BGoiás have over 0.5 first half goals in their last 4 games.
22:00Goiás
Avaí
22-JunNorway ToppserienArna-Bjørnar (w) have over 0.5 first half goals in their last 4 games.
17:00Vålerenga (w)
Arna-Bjørnar (w)
22-JunIceland CupLeiknir Fáskrúds have over 0.5 first half goals in their last 4 games.
18:00Völsungur
Leiknir Fáskrúds
22-JunNorway 1. DivisionGrorud have over 1.5 first half goals in their last 4 games.
16:00Grorud
Start
22-JunIceland 1. Deild WomenÍA (w) have over 0.5 first half goals in their last 4 games.
19:15ÍA (w)
Víkingur Reykjavík (w)
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
Hi,​
use a helper column filled with the date & time stamp then sort the range on this helper column then clear this helper column …​
 
Upvote 0

Forum statistics

Threads
1,223,236
Messages
6,170,912
Members
452,366
Latest member
TePunaBloke

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