Count cells that are text and unique
{=SUM( 1/COUNTIF(cellrange, cellrange))}
Related Formulas
Count cells that are unique numbers
© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited Top
{=SUM( 1/COUNTIF(cellrange, cellrange))}
Count cells that are unique numbers