ollyhughes1982
Well-known Member
- Joined
- Nov 27, 2018
- Messages
- 760
- Office Version
- 365
- Platform
- MacOS
Hi,
This is a further request re my recent post, solved by RobP. I think the second part of it is significant enough to warrant a separate post, as RobP solved the initial request. You can see the earlier thread at the link below:
Run at parkrun events different numbers of consecutive times
Re the below two images, I am trying to come up with a formula in column B4:B2003 of the ‘All Completed Runs - Rutter T’ worksheet, to find when an event (venue) has been completed the number of times stated in column A4:A2003. In the images (and linked file), I have populated these manually (in yellow), to illustrate what I am trying to achieve.
If multiple events have been completed the same number of times I would like to show the event name and date completed of the most recent one completed that number of times.
The ‘All Completed Runs’ worksheet is the original source data.
Link to file (small file and will open quickly) is here: Rutter Triangle.xlsx
Thanks in advance!
Olly.
This is a further request re my recent post, solved by RobP. I think the second part of it is significant enough to warrant a separate post, as RobP solved the initial request. You can see the earlier thread at the link below:
Run at parkrun events different numbers of consecutive times
Re the below two images, I am trying to come up with a formula in column B4:B2003 of the ‘All Completed Runs - Rutter T’ worksheet, to find when an event (venue) has been completed the number of times stated in column A4:A2003. In the images (and linked file), I have populated these manually (in yellow), to illustrate what I am trying to achieve.
If multiple events have been completed the same number of times I would like to show the event name and date completed of the most recent one completed that number of times.
The ‘All Completed Runs’ worksheet is the original source data.
Link to file (small file and will open quickly) is here: Rutter Triangle.xlsx
Thanks in advance!
Olly.