Hi there,
How do I alter the colourfunction module to allow me to count the values for more than one color in a range?
Formula:Please Login or Register to view this content.
Hi there,
How do I alter the colourfunction module to allow me to count the values for more than one color in a range?
Formula:Please Login or Register to view this content.
why not just use it multiple times?
also it appears to be a version of this from ozgrid this one works the one you posted doesnt
Please Login or Register to view this content.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Hi Martin,
It's gonna more tedious if I need to count more than 5 colors in the same range instead... why not modify it to look for 5 colors?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks