D
dhil
Greetings Excel Community,
I have a counting issue that I have not been able to resolve. I have a
large spreadsheet of 800+ rows. One of the columns contains names.
The names may occur more than once (e.g., there may be 15 rows
with the name "John Smith").
My question is: how can I count how many different names occur
over the course of the entire spreadsheet? The end result would be
a number detailing the number of unique names in the worksheet.
Thanks in advance,
Daniel
I have a counting issue that I have not been able to resolve. I have a
large spreadsheet of 800+ rows. One of the columns contains names.
The names may occur more than once (e.g., there may be 15 rows
with the name "John Smith").
My question is: how can I count how many different names occur
over the course of the entire spreadsheet? The end result would be
a number detailing the number of unique names in the worksheet.
Thanks in advance,
Daniel