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
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