ollyhughes1982
Well-known Member
- Joined
- Nov 27, 2018
- Messages
- 677
- Office Version
- 365
- Platform
- MacOS
Hi all.
Please could anyone help with this problem. I am trying to find a solution to find my quickest ’Time’ (column ‘H’) for each unique time period (shown in column ‘AC’ - highlighted in yellow). I want the result to be a 1 if it is the quickest in the period and blank if it isn’t the quickest of that weekly period. I have manually inputted these for now (conditionally formatted to turn pink if a ‘1’), to illustrate what I’m after.
I have attached a Google Drive link to the file below:
(not)parkruns.xlsx
Thanks in advance!
Please could anyone help with this problem. I am trying to find a solution to find my quickest ’Time’ (column ‘H’) for each unique time period (shown in column ‘AC’ - highlighted in yellow). I want the result to be a 1 if it is the quickest in the period and blank if it isn’t the quickest of that weekly period. I have manually inputted these for now (conditionally formatted to turn pink if a ‘1’), to illustrate what I’m after.
I have attached a Google Drive link to the file below:
(not)parkruns.xlsx
Thanks in advance!