Forum Discussion

bbsin's avatar
bbsin
Iron Contributor
May 21, 2022

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) the total repeated attendance from previous event  dates

2) no of new attendees from previous event date

3) no of new attendees from two events dates

 

Can anyone help, what formula to use to work it out?

 

example

let say if the first event is on 11 May 2022

 

Date of Eventtotal attendanceNo of repeated attendees from previous eventNo of fresh attendees from previous eventNo of fresh attendees from two events ago
11 May 2020    
8 Nov 2022    
1 Jan 2021    
8 May 2021    

 

 

Thank you 

 

 

excel
  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Aug 09, 2022

    bbsin 

    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?

     

Resources