Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Complex query question
Here's what I've got to do:
Column Row Priority Rating 1, 2, or 3 CIA Rating (spread over three columns) 0, 1, 2, or 3 - can be any combination of three digits (ex: 011, 111, etc) Priority Validation ODD or EVEN I need to count the number of records by country (Country names are located in column D) where records with the following conditions meet: 1) # of records where Priority Validation ODD or EVEN is missing for Priority Rating 3 Applications 2) # of records where CIA Rating 011 is missing a Priority Rating of 3 3) # of records where CIA Rating 111 is missing a priority Rating of 3 Can anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Query cannot be edited by the Query Wizard" | Excel Discussion (Misc queries) | |||
complex count question | Excel Worksheet Functions | |||
Question about Query Wizard | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Jon Peltier - Pivot Table Result for yesterday's "Complex Chart" Question | Charts and Charting in Excel |