ollyhughes1982
Well-known Member
- Joined
- Nov 27, 2018
- Messages
- 793
- Office Version
- 365
- Platform
- MacOS
Hi all,
Re below images:
I am trying to find a way to achieve a formula that fulfils the logic in A2 of the ‘All Completed Runs - Period’ worksheet. i.e. What I want to do is, find where I have completed a parkrun in the ‘All Completed Runs’ worksheet that satisfies the following criteria:
Thank in advance!
Olly.
Re below images:
I am trying to find a way to achieve a formula that fulfils the logic in A2 of the ‘All Completed Runs - Period’ worksheet. i.e. What I want to do is, find where I have completed a parkrun in the ‘All Completed Runs’ worksheet that satisfies the following criteria:
- The parkrun name begins with the first letter (i.e. the first character) of the Chemical Symbol - Look for this in column AS of the ‘All Completed Runs’ worksheet
- …The parkrun name contains the second letter of the Chemical Symbol, exclduing the first character (look for this in column BX of the ‘All Completed Runs’ worksheet)
Thank in advance!
Olly.