Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting number of items excluding duplicates.
I currently have a table of 120 products that includes duplicates.
I would like to count how many different products are included in this 120. For example: Product A A A B C C F E There are 8 total products listed, but only 5 different products. Is there a way to count how many different products are listed. I tried a pivot table but I don't need the total each product is listed, just the total number of products. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting number of items excluding duplicates.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting number of days excluding certain values | Excel Discussion (Misc queries) | |||
Counting Cells in a column depending on another column but excluding duplicates | Excel Discussion (Misc queries) | |||
counting unique items within categories - but EXCLUDING blank cell | Excel Worksheet Functions | |||
Requesting Help with Counting in a Pivot but Excluding Duplicates | Excel Worksheet Functions | |||
Count number of unique items in a column that contains duplicates | Excel Worksheet Functions |