Using a filter is the easiest way.

Filter on the score column.

Select any column header
Goto DataFilterAutoFilter
Then click the drop arrow on the Score column
Select Customis less than90

Copy the filtered data to your other sheet.

Biff

"Pat" wrote in message
...
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