Hi,
could i please ask for some more help
i am looking for a formula to report from a list of data but to ignore the "0", and only report back with the values for orange and grey
I would like to see ;
Orange (1), Grey (4)
if this report was to change then the result would be reflected in the above formula
many thanks
could i please ask for some more help
i am looking for a formula to report from a list of data but to ignore the "0", and only report back with the values for orange and grey
I would like to see ;
Orange (1), Grey (4)
if this report was to change then the result would be reflected in the above formula
many thanks
Black | 0 | 0 |
Blue | 0 | 0 |
Yellow | 0 | 0 |
Red | 0 | 0 |
White | 0 | 0 |
Green | 0 | 0 |
Pink | 0 | 0 |
Purple | 0 | 0 |
Clear | 0 | 0 |
Orange | 1 | 1 |
Cream | 0 | 0 |
Grey | 4 | 3 |
Brown | 0 | 0 |