Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I've got a database of test scores:
Name----# MISSED------Score------Questions Missed --- A-----------0--------------100 B-----------1--------------97-----------1 C-----------6--------------80-----------1---2---3---4---7---9 D-----------2--------------93-----------2---6 E-----------5--------------83-----------1---2---3---4---5 F-----------4--------------87-----------1---3---4---5---7 G-----------6--------------80-----------4---6---7---8---9---10 I'm trying to have all the data from those individuals that scored <90 report on another worksheet. I haven't figured out how to get excel to search the SCORE column for scores <90 and report all occurrences... I can get it to report the first score <90, but don't know how to make it report all of them. Any insight would be greatly appreciated. Pat Matak |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Reporting with Database function | Excel Discussion (Misc queries) | |||
Links to External Database | Excel Discussion (Misc queries) | |||
Excel Worksheet Form / Database reporting | Excel Discussion (Misc queries) |