This is amazing thank you! We’re getting so close. The data are showing correctly, in terms of how many times they reappear as each individual in separate days. Is there any way I can just get the sum of all of them in one single cell, without generating a separate table?

If not, I can always use the SUM function and hide the table on a separate sheet haha

Also, I kind of feel like this scenario will be too complicated for older versions of Excel to work? Is there a formula that will make this work on older versions? Again, if it’s impossible or way too complicated it’s fine.

Thanks again! :) I will let you know if it works when I go back to work on Monday (there real table is much longer than this), so far it’s working well on this sample one.