I am trying to produce a function for a dashboard which shows the number names on a list that appear more than once.
For example in below list the cell would populate the number 3 since there are 3 names that have ≥2 occurrences:
Andy
Andy
Andy
Ben
Jake
Jake
Sarah
Sarah
Sarah
Sarah
Any help is greatly appreciated and let me know if more information is required.
Bookmarks