View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Btaylor64 Btaylor64 is offline
external usenet poster
 
Posts: 7
Default counting unique items within categories - but EXCLUDING blank

Domenic,
You're absolutely correct; now it works fine! Not sure what I was
doing wrong before. Thanks again for your help!
-Brett


"Domenic" wrote:

The formula as I posted it looks fine. I tried it just to be sure and
had no problems. Did you copy/paste the formula? Try typing it out
manually instead of copy/paste.

In article ,
Btaylor64 wrote:

Domenic,
Looks like there's a parentheses issue in the formula below? I tried
to troubleshoot this using the colored parenthese font that Excel provides,
but no luck. All the combinations of parentheses placement I've tried give
me errors...
Any thoughts?
Gratefully,
-Brett