I have a file that contains multiple worksheets (by date) with each worksheet containing a list of names. I would like to create a summary page which details all the names in alphabetical order from the data sheets and counts the number of times they appear. For example,
Sheet 1: 25-06
User
Person 1
Person 2
Person 2
Person 3
Person 4
Person 4
Person 4
Person 8
Person 8
Person 9
Sheet 2: 26-06
User
Person 1
Person 1
Person 1
Person 8
Person 9
Person A
Summary: To contain
User 25-06 26-06
Person 1 1 3
Person 2 2
Person 3 1
Person 4 3
Person 8 2 1
Person 9 1 1
Person A 1
Attached Example, Book1.xlsx
Thanks in advance for any help
Bookmarks