View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
FifthFormula FifthFormula is offline
external usenet poster
 
Posts: 5
Default Unique project names with complex array formulas

Project Approved Type TypeSummary "HowManyProj"
-------- ----------- ----- ---------------- ----------------
Green 1/5/08 Charity Charity 3
Green 1/5/09 Profit Profit 2
Blue 1/7/09 Neutral Neutral 1
White 1/7/08 Profit
Red Charity
Blue 1/15/09 Charity
Green Profit
Yellow 1/16/08 Charity
Green Charity

Manual answer is "How Many Projects"
How do I develop a formula that will tell me "How Many Unique Project Names"
of the "Charity" type have an "Approval Date"(3, Green, Blue, Yellow)
How many unique of the "Profit" type have an approval date (2, Green, White)
And how many unique of the "Neutral" type have an approval date (1, blue)
Quite a challenge.
--
Jorge.R