Forum Discussion
bbsin
May 21, 2022Iron Contributor
urgent need help -how to find repeated attendance/ new attendance of same event of different dates?
hi can anyone advise. We have an event (Skill Event) that happens 4 times a year and the attended list of people who attended by department and email address I need to find 3 things 1) th...
OliverScheurich
Aug 09, 2022Gold Contributor
Formula in C3:
=MIN(B3,B2)Formula in D3:
=IF(B3>B2,B3-B2,"")Formula in E3:
=IF(B3>B1,B3-B1,"")Is this what you are looking for?
bbsin
Aug 10, 2022Iron Contributor