LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 39
Default help with formulas

I have a list of applications that have gone overdue. Here is a sample of my
list:

Program Code Case # Delay Code
P60 401133012
P60 721283900 AG
P30 821362112
P30 828190110
P60 950351513 CI
L60 217075010 CI
S60 810474413 OA
Q30 235391903 OA
S60 167004803 OA
S30 893474708 OA
S30 676254115 CI
S60 712233808

There are several different program codes for the applications, and a few
different delay codes, leading to several different needs to count for the
list. I am trying to figure out how I can count, for example, the number of
P60 applications that had a delay code of "CI", or the number of Q30
applications that had a delay code of "OA", or the number of S60 applications
that had no delay code, etc.

Please help!



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
E2007 formulas display as formulas, not results Pierre Excel Worksheet Functions 3 January 14th 10 04:59 PM
Counting # of Formulas in a column with formulas and entered data Brand Excel Worksheet Functions 1 October 10th 09 01:01 PM
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP Sherberg Excel Worksheet Functions 4 September 11th 07 01:34 AM
Formulas not evaluated, Formulas treated as strings Bob Sullentrup Excel Discussion (Misc queries) 0 November 27th 06 08:01 PM
formulas for changing formulas? creativeops Excel Discussion (Misc queries) 4 January 26th 06 03:07 AM


All times are GMT +1. The time now is 04:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"