Count unique names in a nomination spreadsheet

[jwoww]

I've asked chat gpt to help me count the number of names in a column that I'm recording for a work nomination event.

It's recommended the following

=SUM(1/COUNTIF(range, range))

And

=COUNTA(UNIQUE(range))

Both return the value of one when I know there is atleast 11 in the first sheet I've tried it on

 

[Michael M]

some sample data might help solve the issue.

 

[jwoww]

some sample data might help solve the issue.

Apologies as the worksheet contains personal information I am limited in what i can show.

What I can say is that worksheet 1 contains my overview of the various categories and I've been able to calculate how many nominations for each category there are. On each of the other worksheets (one for each category) column a is where people's names appear and column b is where there are comments about them and the work they do. I want to be able to count how many different names appear in column a ie. Whilst there may be 15 overall nominations, there are only 10 people nominated overall (with a few people nominated more than once)

Hope that makes sense

 

[Fluff]

What happens if you just use

=UNIQUE(range)

 

[RoryA]

What did you put in for the actual range?

 

[jwoww]

What happens if you just use

=UNIQUE(range)

It errors out and returns #NAME?

 

[jwoww]

What did you put in for the actual range?

In the formula, where it references range, I select the whole column that has the names that I am wanting to receive information about

 

[Michael M]

Have you tried reducing the selected from the entire column to a fixed amount of data, simply to test the formula ??
As mentioned previously, some dummy data may help if the columns / rows are consistent.

 

[RoryA]

So your formula looked something like:

=COUNTA(UNIQUE(A:A))

and still returned 1?

 

[jwoww]

So your formula looked something like:

=COUNTA(UNIQUE(A:A))

and still returned 1?

That's correct.

I can't attach a photo off my phone of what the spreadsheet looks like. But column a is just filled with peoples names and that's what I'm trying count how many different names appear