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