This might be something that would help to get the last value for a user:
This contains a piece about using COUNTIF with concatinated values instead of COUNTIFS:
This might be something that would help to get the last value for a user:
This contains a piece about using COUNTIF with concatinated values instead of COUNTIFS: