Forum Discussion
peeblescd2020
Mar 07, 2020Copper Contributor
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...
yydhcl
Mar 07, 2020Copper Contributor
peeblescd2020 =SUMPRODUCT(IFERROR(1/COUNTIF(S2:S1000,S2:S1000),0))
- BEN_FAWKESMar 07, 2020Copper Contributor