Hi, I have code that I use as a personal macro on my ribbon that lets you highlight a list of cells and it pastes this to another tab and removes duplicates so I can get a unique count:
Sub List_Unique_Values()
'Create a list of unique values from the selected column
Dim rSelection As Range...