Library users - Excel formula for making a list and count

[Oncology]

Dear Excel forum users,

my name is David, a librarian from the Institute of Oncology Ljubljana.

Would anybody on the forum be so kind and help me to solve my problem: in sheet C we would like to have automatically written:

- a list of our library users (Surname Name) - column A,

- and in column B summary of users' actions/requests - how many times did someone request our service


Thank you for your help in advance.


Regards,

David