counting how many different numbers in a row

[AmandaSS]

Hi,

I am in need to find a way to calculate how m any different numbers in a row.
To explain myself I give you an example.
I have a row of 6 cells. In each cell there is a figure (which represents a price) like following:


10 20 10 10 6 20

in this row I have six cells, each of them containing a price, but only 3 different prices (10 , 20 and 6).
What I need is to create a 7th column that gives me how many different numbers are in that row. In this case 3.

Thanks a lot. I hope I was able to explain the issue
Best
Amanda

 

[Richard Schollar]

Hi Amanda

Assuming your numbers are in A1:F1 then in G1:

=SUMPRODUCT((A1:F1<>"")/COUNTIF(A1:F1,A1:F1&""))

 

[AmandaSS]

Richard, thanks so much
I made it

 

[Richard Schollar]

You're welcome