Forum Discussion
count unique cell text values
Hi, I'm trying to create a formula which counts the unique number of country names in the second sheet of column S attached. I want the range to be the entire column since we're continuously adding d...
I presume you don't have 365 and access to UNIQUE...
=SUM(IF(FREQUENCY(IFNA(MATCH($S$2:$S$1000,$S$2:$S$1000,0),0),IFNA(MATCH($S$2:$S$1000,$S$2:$S$1000,0),0))>0,1))-1
Press Ctrl Shift Enter to calculate the formula as an array.