Count the number of times a user has logged in

[kristell]

Hi can somebody please help me with columns E F and G for this?

Each individual log in for a person is in A & B and I am looking for the earliest date they logged in and the latest date and then the total number of times they have logged in, and the number of days since they last logged in?
Col D is the list with duplicates removed to make it easy to see - so I will hide A & B in my report. This is a short example - there are around 60598 actual values in col A.

The formulas I have tried are in the first graphic - but they don't seem to work - think I am not putting some $ in were I should! The green in H is where they are over 60 days - conditional formatting.

I hope this makes sense to you!

 

[kristell]

Sorry - that should say Col C is the list with duplicates removed

 

[myall_blues]

Minimum: =MINIFS(B$2:B$60598,A$2:A$60598,C2)
Maximum: =MAXIFS(B$2:B$60598,A$2:A$60598,C2)

Your COUNTIF formulas look OK?

 

[kristell]

Brilliant - thank you so much!