Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting only unique values.
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting only unique values.
Anders, maybe a Pivot table could help you a lot
regards from Brazil Marcelo "a94andwi" escreveu: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting only unique values.
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? -- a94andwi ------------------------------------------------------------------------ a94andwi's Profile: http://www.excelforum.com/member.php...o&userid=21077 View this thread: http://www.excelforum.com/showthread...hreadid=547422 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print unique values | Excel Worksheet Functions | |||
unique values in a cell base on another cell | Excel Discussion (Misc queries) | |||
Count unique values - Pivot Table | Charts and Charting in Excel | |||
create list of unique values from a column with repeated values? | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions |