DISTINCTCOUNT

[GeertD]

DISTINCTCOUNT: Count the unique elements in an Array, regardless of their frequencies.

=LAMBDA(Array,
   COUNTA(UNIQUE(Array))
)

DXLR's LAMBDA.LET Library_v00.07.xlsb
	A	B	C	D	E	F	G	H	I	J
1	Just a table:
2	First Name	Last Name	Score	Country			CountRows:	20
3	Alice	Livingstone	6	Germany			DistinctCount:	14	(First Name)
4	Mikayla	Lindberg	14	Germany
5	Charles	Hurst	3	Poland
6	London	Edmund	1	Argentina
7	Myla	Stukeby	5	Germany
8	Xzavier	Angus	4	Romania
9	Mikayla	Slater	14	Mexico
10	Alice	Poole	4	Finland
11	Alice	Johansen	34	Mexico			DistinctCount:	16	(Score)
12	Karl	Tilton	11	Mexico
13	Mikayla	Bruno	18	Finland
14	Paxton	Chadsey	3	USA
15	Lamont	Lacy	17	Slovakia
16	Jaylan	Forbes	9	Egypt
17	Paxton	Beckley	15	Brazil
18	Alejandra	Donoso	22	Spain
19	Deonte	Astley	13	Thailand
20	Alfred	Sarisbury	27	Argentina
21	Karl	Ingoldsby	13	Germany
22	Rylan	Hasbrouck	33	Indonesia
23
Sandbox_Mr.Excel

Cell Formulas
Range	Formula
H2	H2	=COUNTA(tblTop[First Name])
H3	H3	=DistinctCount(tblTop[First Name])
H11	H11	=DistinctCount(tblTop[Score])