ollyhughes1982
Well-known Member
- Joined
- Nov 27, 2018
- Messages
- 677
- Office Version
- 365
- Platform
- MacOS
Hi. In my file (link below) and worksheet 'Completed Unique E(V)', is there a way to make it auto-populate column B (and subsequently the other columns), rather than the manually entered entries I have at the moment? I have tried various ifs, matches and vlookups etc. but can't seem to get it to work. I just want it to pick up the first instance (i.e. all those that have 1 in column AO in the ‘All Completed Runs’ worksheet) of each event from column C in the ‘All Completed Runs’ worksheet. So I then have a list of my unique events, as per the manual entries now. I assume I then just offset or something to populate the other cells on each row?
parkrun - My parkrun Record - WORKING.xlsx
Thanks!
parkrun - My parkrun Record - WORKING.xlsx
Thanks!