Count unique values in a range of cells

Good Afternoon,

I'm not sure if I am overthinking this, but I am having a lot of trouble getting to a result I am happy with. Essentially what I am trying to do is:

1. Get a list of unique names from a range of cells (10 columns, 150 rows max)
2. Count the number of times each name appears on the list

The master data sheet lists a unique project for each row with multiple columns. Near the end of the worksheet, there are 10 columns labeled Key Stakeholder 1 - 10 which contain a number of values. Some projects only have 1 stakeholder and others have many. To add to this, they are not sorted (e.g. Bob Jones could be listed in columns 1, 4, 8, and 9 on different rows). I estimate that in total there could be up to 50 unique stakeholders added to the sheet in this manner.

I'm not sure if this can be done in 1 step or requires 2, but I would like the output to be:

Column A - Lists all unique stakeholder names
Column B - Total count of projects each name is assigned to

THANK YOU!!!

Hi,

Might be helpful for you to upload a file here.

The answer to counting unique values in a range is

Formula:

Please Login or Register  to view this content.

Where your values are in A1:A10.

But I dont know if this is what you are after?