View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pat Pat is offline
external usenet poster
 
Posts: 210
Default Problems searching a database and reporting all occurrences of a v

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