Check if Value appears in same list for the following month

[Eclektics]

Hi Guys,

Really struggling to figure a way out how to do this but hoping someone can help.

I have a list of staff members updated monthly, it's all on the same sheet with the month and year entered in a cell to show when this was added. I want a formula that is able to check if a name appears later in the list for the next month. i.e. John Smith - Aug-23 doesn't have a record for Sep-23 so I want a formula next to his August entry to show 0 as he doesn't appear.

Any help would be massively appreciated as currently this is a manual and time consuming. I've included an image of how it would look below.

Thanks

 

[Legacy 143009]

Assuming Names Column A, Dates Column B
C2 Formula will be:

=COUNTIFS(A3:$A$100, A2, B3:$B$100, EDATE(B2, 1))

 

[Eclektics]

Assuming Names Column A, Dates Column B
C2 Formula will be:

=COUNTIFS(A3:$A$100, A2, B3:$B$100, EDATE(B2, 1))

Thats it! Nailed it in one, thank you so much!

Been scratching my noggin for weeks.

 

[Legacy 143009]

Thats it! Nailed it in one, thank you so much!

Been scratching my noggin for weeks.

Happy it did worked Thanks for the feedback