Results 1 to 2 of 2

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

Threaded View

Pat Matak Search column and report all... 12-19-2006, 07:06 PM
Bryan Hessey One option is to use a helper... 12-19-2006, 08:23 PM
  1. #1
    Registered User
    Join Date
    12-19-2006
    Posts
    1

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

    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
    Last edited by Pat Matak; 12-19-2006 at 07:09 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1