Search column and report all row data for each occurrence of a test score <90

[Pat Matak]

I've got a database of test scores:

Name----# MISSED------Score------Questions Missed ---
A-----------0--------------100
B-----------1--------------97-----------1
C-----------4--------------87-----------1---2---3---4
D-----------5--------------83-----------1---2---3---4---5

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

[Bryan Hessey]

I've got a database of test scores:

Name----# MISSED------Score------Questions Missed ---
A-----------0--------------100
B-----------1--------------97-----------1
C-----------4--------------87-----------1---2---3---4
D-----------5--------------83-----------1---2---3---4---5

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

One option is to use a helper column with

=If(A1<90,"Y","")

and AutoFilter on that column, select Y

you can then copy all rows to another loaction, either by select & copy, or by Advanced Filter, Copy to New location.

This is useful for a once-off, but a little heavy to do every day.

Does this help your needs?
---