Hello.

I have a list containing supplier number, supplier name, part number,
and controller for this part number/Supplier.

The worksheet contains 7000 rows and I need to get how many suppliers
that are connected to each controller.

As you can imagine there are several parts that are connected to the
same supplier and controller so if I sum each row the result will not
be correct.

I would normally use Sumprocuct but if I only want to count unique
supplier numbers then I get the wrong result.

Is there a way to search through a database and count how many
suppliers there are that have a predefined controller.

I hope you understand. It is hard to translate my swedish thinking to
english words.

/Anders


--
a94andwi
------------------------------------------------------------------------
a94andwi's Profile: http://www.excelforum.com/member.php...o&userid=21077
View this thread: http://www.excelforum.com/showthread...hreadid=547422