ollyhughes1982
Well-known Member
- Joined
- Nov 27, 2018
- Messages
- 677
- Office Version
- 365
- Platform
- MacOS
Hi all,
Re the screenshots above, I currently have the below formula in BJ11:
=IF(C11="","",IF(OR(C11="",F11=F10),"",COUNT(UNIQUE($F$4:F11))))
This is however missing something. I also need to add in the criteria that a new number needs to be added to the sequence if C11 is different to C10. This is because it is possible to volunteer at two separate parkruns on the same day. So, the numbering needs to account for situations where the date is the same, but the venue is different.
I would expect to see 6 in cell BJ11 and 7 in BJ12. This is because I volunteered later in the day on 29/08/2021 at a different venue (Cwmbran). For the first three roles I did that day, they were all at Newport junior parkrun.
N.B. An 'Occasion' signifies each unique venue that is volunteered at on a particular date. hence having Newport junior and Cwmbran on 29/08/2021 equals two different occasions (6th and 7th).
Thanks in advance,
Olly.
Re the screenshots above, I currently have the below formula in BJ11:
=IF(C11="","",IF(OR(C11="",F11=F10),"",COUNT(UNIQUE($F$4:F11))))
This is however missing something. I also need to add in the criteria that a new number needs to be added to the sequence if C11 is different to C10. This is because it is possible to volunteer at two separate parkruns on the same day. So, the numbering needs to account for situations where the date is the same, but the venue is different.
I would expect to see 6 in cell BJ11 and 7 in BJ12. This is because I volunteered later in the day on 29/08/2021 at a different venue (Cwmbran). For the first three roles I did that day, they were all at Newport junior parkrun.
N.B. An 'Occasion' signifies each unique venue that is volunteered at on a particular date. hence having Newport junior and Cwmbran on 29/08/2021 equals two different occasions (6th and 7th).
Thanks in advance,
Olly.