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.
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.
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