ollyhughes1982
Well-known Member
- Joined
- Nov 27, 2018
- Messages
- 677
- Office Version
- 365
- Platform
- MacOS
Hi all,
Would anyone please be able to help with three calculations in my ‘All Completed Runs - Summary’ worksheet. In cells B117:B119 I am trying to find a way to list my ‘Hoffman’, ‘Bailey’ and ‘Full Bailey’ progress. The definition for this club is:
"XinX" is running at a number of different 5k parkrun venues before running at a venue for a second time - so the parkrunner has run "X" different Events in their first "X" parkruns.
For me, I repeated Newport in my fifth run, so my Hoffman, Bailey and Full Bailey result is 4. i.e. I ran 4 events before ever repeating one. The relevant cells should display as follows:
This can now never change as it is the first time you ever repeat an event, and then that’s it.
I’m guessing this is likely to be a IF formula type solution that’s needed.
Link to file here: Hoffman, Baily, Full Bailey.xlsx
Thanks in advance!
Would anyone please be able to help with three calculations in my ‘All Completed Runs - Summary’ worksheet. In cells B117:B119 I am trying to find a way to list my ‘Hoffman’, ‘Bailey’ and ‘Full Bailey’ progress. The definition for this club is:
"XinX" is running at a number of different 5k parkrun venues before running at a venue for a second time - so the parkrunner has run "X" different Events in their first "X" parkruns.
For me, I repeated Newport in my fifth run, so my Hoffman, Bailey and Full Bailey result is 4. i.e. I ran 4 events before ever repeating one. The relevant cells should display as follows:
- B117: '4' / C117 '4 out of 50'
- B118: '4' / C118 '4 out of 100'
- B119: '4' / C119 '4 out of 250'
I’m guessing this is likely to be a IF formula type solution that’s needed.
Link to file here: Hoffman, Baily, Full Bailey.xlsx
Thanks in advance!