Getting only unique values.

[a94andwi]

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

 

[Marcelo]

Anders, maybe a Pivot table could help you a lot

regards from Brazil
Marcelo

"a94andwi" escreveu:

 

[a94andwi]

Hello.

Unfortunately I can not use pivottable.

I have a macro that gets all controllers from the database and via an
advanced filter. I then only get unique records and it works great.
in the cell next to the controller number I need the number of
suppliers that the controller are in charge of.

In text I need this to happen:
"Count all unique suppliernumbers from the database where the
controller is like in CellA1"

Is there a function that can help me with this?