Sorry,
I couldnt get to the thread in time to mention that I needed to do an Ifs rather than an If because I need 2 different parameters to be specific values.
Heres what I did to mark the thread SOLVED....
I did a COUNTIFS for each sector (which worked out better for my purposes anyway because I do want to see that)
Example:
Then I did an If for each COUNTIFS to identify if true false:
Example:
Then I did in a single cell, a SUM of all the 11 different IF
Example:
That Sum gave me the unique value count I was originally asking for so now, as you mention, I can conditionally format to my hearts content!
FYI, I tried the:
but it did not produce valid results.... got the ole' #DIV/0!.... and yes, I set as an array.
Thanks for the help though!!!
Bookmarks