For say 100 items:

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


--
Gary''s Student


"cj21" wrote:

>
> I have a list of products, each of which has a tarifff. e.g.
>
> Product...Tariff
> 01234563 10
> 01423467 10
> 01423578 20
> 13466989 5
> 10457904 25
> 14456893 30
> 20345076 5
> 34056097 20
>
> I want a formula that counts how many different tariff values there
> are. In this example there are 5. Is this possible?
>
> Thanks
>
> Chris
>
>
> --
> cj21
> ------------------------------------------------------------------------
> cj21's Profile: http://www.excelforum.com/member.php...o&userid=25673
> View this thread: http://www.excelforum.com/showthread...hreadid=512219
>
>