software

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: www.excelforum.com/member.php...oamp;userid=25673
View this thread: www.excelforum.com/showthread...hreadid=512219
Why not put a pivot table to the side of your data and use it to list
all tariffs - as a bonus it will tell you how many of each there are.--
bob777
------------------------------------------------------------------------
bob777's Profile: www.excelforum.com/member.php...oamp;userid=28504
View this thread: www.excelforum.com/showthread...hreadid=512219Hi Chris,

Don't ask me how it works. I just copied it from a Google search.

=SUMPRODUCT((B1:B8lt;gt;quot;quot;)/COUNTIF(B1:B8,B1:B8amp;quot;quot;))

--
Kind regards,

Niek Otten

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

=SUMPRODUCT((A1:A100lt;gt;quot;quot;)/COUNTIF(A1:A100,A1:A100amp;quot;quot;))--
Gary''s Studentquot;cj21quot; wrote:

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

Hi Niek,

I had a go at explaining it a while back in tinyurl.com/dhbxe

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Niek Ottenquot; gt; wrote in message
...
gt; Hi Chris,
gt;
gt; Don't ask me how it works. I just copied it from a Google search.
gt;
gt; =SUMPRODUCT((B1:B8lt;gt;quot;quot;)/COUNTIF(B1:B8,B1:B8amp;quot;quot;))
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;cj21quot; gt; wrote in
message
gt; ...
gt; gt;
gt; gt; I have a list of products, each of which has a tarifff. e.g.
gt; gt;
gt; gt; Product...Tariff
gt; gt; 01234563 10
gt; gt; 01423467 10
gt; gt; 01423578 20
gt; gt; 13466989 5
gt; gt; 10457904 25
gt; gt; 14456893 30
gt; gt; 20345076 5
gt; gt; 34056097 20
gt; gt;
gt; gt; I want a formula that counts how many different tariff values there
gt; gt; are. In this example there are 5. Is this possible?
gt; gt;
gt; gt; Thanks
gt; gt;
gt; gt; Chris
gt; gt;
gt; gt;
gt; gt; --
gt; gt; cj21
gt; gt; ------------------------------------------------------------------------
gt; gt; cj21's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=25673
gt; gt; View this thread:
www.excelforum.com/showthread...hreadid=512219
gt; gt;
gt;
gt;
Thanks, Bob!--
Kind regards,

Niek Otten

quot;Bob Phillipsquot; gt; wrote in message
...
gt; Hi Niek,
gt;
gt; I had a go at explaining it a while back in tinyurl.com/dhbxe
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Niek Ottenquot; gt; wrote in message
gt; ...
gt;gt; Hi Chris,
gt;gt;
gt;gt; Don't ask me how it works. I just copied it from a Google search.
gt;gt;
gt;gt; =SUMPRODUCT((B1:B8lt;gt;quot;quot;)/COUNTIF(B1:B8,B1:B8amp;quot;quot;))
gt;gt;
gt;gt; --
gt;gt; Kind regards,
gt;gt;
gt;gt; Niek Otten
gt;gt;
gt;gt; quot;cj21quot; gt; wrote in
gt; message
gt;gt; ...
gt;gt; gt;
gt;gt; gt; I have a list of products, each of which has a tarifff. e.g.
gt;gt; gt;
gt;gt; gt; Product...Tariff
gt;gt; gt; 01234563 10
gt;gt; gt; 01423467 10
gt;gt; gt; 01423578 20
gt;gt; gt; 13466989 5
gt;gt; gt; 10457904 25
gt;gt; gt; 14456893 30
gt;gt; gt; 20345076 5
gt;gt; gt; 34056097 20
gt;gt; gt;
gt;gt; gt; I want a formula that counts how many different tariff values there
gt;gt; gt; are. In this example there are 5. Is this possible?
gt;gt; gt;
gt;gt; gt; Thanks
gt;gt; gt;
gt;gt; gt; Chris
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; --
gt;gt; gt; cj21
gt;gt; gt; ------------------------------------------------------------------------
gt;gt; gt; cj21's Profile:
gt;gt; gt; www.excelforum.com/member.php...oamp;userid=25673
gt;gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=512219
gt;gt; gt;
gt;gt;
gt;gt;
gt;
gt;