Count unique number in a cell

[mahmoud-lee]

I want to collect the number of unique numbers in cell
I use Office 2003

[Admin]

Hi

Define ;

Select A2 and hit CTRL + F3

Name: StrNum
Refers to: =EVALUATE("{"&SUBSTITUTE(Sheet1!$A2,",",";")&"}")


Click OK

and use the formula

=SUM(IF(FREQUENCY(StrNum,StrNum)>0,1))

[mahmoud-lee]

Wonderful
Thank you very much

[mahmoud-lee]

What if we wanted to collect the unique values ​​in the entire column