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

 

[RoryA]

And you are definitely using this on 365 not an earlier version?