Need count of distinct values in multi-column range

[billmarshall]

I am trying to get a distinct count from a multi-column range. I've tried the UNIQUE formula in many permutations (with COUNTA), and it is not giving me the right answer. The multi-column range example here is 50 total values, with 37 distinct values. So 37 is the answer I'd expect. I've also tried this formula : =SUM(IF(COUNTIF(G2:K11,G2:K11)=1,1,0)) but it's giving me an answer of 26, which is not correct.

Any help would be greatly appreciated. Thanks!

 

[Fluff]

I've tried the UNIQUE formula

That function doesn't exist in 2019, so what version are you using for this?

 

[billmarshall]

Here's my version : Microsoft® Excel® for Microsoft 365 MSO (Version 2210 Build 16.0.15726.20070) 64-bit

 

[Fluff]

Ok, thanks for that, how about

=ROWS(UNIQUE(TOCOL(G2:K11,1)))

 

[billmarshall]

Ok, thanks for that, how about

=ROWS(UNIQUE(TOCOL(G2:K11,1)))

Perfect, thank you!

 

[Fluff]

You're welcome & thanks for the feedback.