View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dan the Man[_2_] Dan the Man[_2_] is offline
external usenet poster
 
Posts: 145
Default Possibly an Array, but I'm not sure?

Column A Column B Columm C

Row 3 Aug 1, 2008 Joe Jones 91%
Row 4 Mar 15, 2008 Mary Doe 86%

Lookinig for a formula to provide me with a statistical information by the
four quarters of the yeaer(e.g. quarter one would be Jan 1-March 30, 2008).
What I want to anaylyze is a percentage breakdown. For example, I want to
know how many individuals show outcomes at 91% or more. Thus, the formula
might generate an outcome that tells me that 15 of the total individuals on
my spreadsheet scored at 91% or greater.

I'll also have to breakdown other percentage parameters (e.g. outcomes
between 75-89%, etc), however once I get the outline of a formula I should be
able to do the rest. I'm thinking I need an array formula, but I just wasn't
sure how to get what I wanted. Thanks much in advance.

Dan