Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
count if (possibly?!) | Excel Worksheet Functions | |||
Please help! - Possibly need a Macro? | Excel Worksheet Functions | |||
HELP with function, possibly code! | Excel Worksheet Functions | |||
Lookup possibly? | Excel Discussion (Misc queries) | |||
If Statement possibly? | Excel Worksheet Functions |