Hi all,
I currently have a table like the below where the rank is based on the order of the table.
I want to rank it based on the location and time (table 2)
Can anyone help with this please?
| Location |
Time |
Rank |
| Manchester |
00:15 |
1 |
| Liverpool |
00:30 |
2 |
| Manchester |
00:45 |
3 |
| Reading |
01:00 |
4 |
| Reading |
01:15 |
5 |
| Manchester |
01:30 |
6 |
| Bristol |
01:45 |
7 |
| Liverpool |
02:00 |
8 |
| Bristol |
02:15 |
9 |
| Bristol |
02:30 |
10 |
| Liverpool |
02:45 |
11 |
| Location |
Time |
Rank |
| Manchester |
00:15 |
1 |
| Liverpool |
00:30 |
1 |
| Manchester |
00:45 |
2 |
| Reading |
01:00 |
1 |
| Reading |
01:15 |
2 |
| Manchester |
01:30 |
3 |
| Bristol |
01:45 |
1 |
| Liverpool |
02:00 |
2 |
| Bristol |
02:15 |
2 |
| Bristol |
02:30 |
3 |
| Liverpool |
02:45 |
3 |
------------------------------
Ricky Butler
------------------------------