Wondering if its possible with the same example to actually count the distinct values in the given column
I'm aware that I can get distinct count (including text) by saying: =SUM(IF(FREQUENCY(IF(LEN(H3:H11243)>0,MATCH(H3:H11243,H3:H11243,0),""), IF(LEN(H3:H11243)>0,MATCH(H3:H11243,H3:H11243,0),""))>0,1)) as an array....
from the formula given by Roger:
is it possible to get distinct count similar to abovementioned so that instead of getting a sum from F16:F20 --> I actually get distinct count from J16:J20?
Would this be possible without the use of macros?
Thanks in advance