Readers like you help support MUO. When you make a purchase using links on our site, we may earn an affiliate commission. Read More.

In my first column I have a list of names and I need to get the sum of the total unique names as a numerical value.

e.g. the first column has:

lokesh

mahesh

venkat

lokesh

mahesh

venkat

lokesh

mahesh

venkat

I would need the formula to output "3", because there are only 3 separate names in the column.

Paul P
2013-07-18 15:11:28
Make a copy of the column. Put it in another worksheet. Use remove duplicates on the Data menu and voila you get a count of unique names. For a formula though, that's more work and I'm not awake yet.
MAKEUSEOF VIDEO OF THE DAY
SCROLL TO CONTINUE WITH CONTENT
Hovsep A
2013-07-18 08:07:35
use a pivot table - first select your list (including the header) then go Data-Pivot Table and pivot Chart and follow the dialogue prompts to create a pivot table. Count of Each Item in a List See Also: Count of Items in List COUNTIF || Count Only One Occurrencehttp://www.ozgrid.com/VBA/count-of-list.htm