Hi,
I need some help to find a formula (Excel 2003 otherwise Excel 2010).
I have this table:
I need to count unique value of range C2:F5 with condition in B:B "METAL"
A B C D E 1 model type color1 color2 color3 2 aaa metallized gray red blue 3 bbb MATT white black 4 ccc metallized gray green 5 ddd MATT white black red
Example:
METAL = 4 (gray, red, blue, green)
matte = 3 (white, black, red)
... if it's possible also the subtotale if apply a filter in column A.
Thank for the help.
Bookmarks