My chart is as follows:

Name------------Company---------Date-----------Score--------Pass/Fail
????-------------?????????--------??/??/????--------??-----------????
**
(** this says Pass if the score is 10, fail if it is between 0 and 10,
"Not Evaluated" if the score is 0, and "Invalid" if the score is above
10)
and the list continues with many names.

I want to make two seperate charts that retrieve information from the
above chart.

The first one will retrieve only the names of the people who have done
the test but the tests have *not* been evaluated. I would like it in
the same type of format, with name, company, date, etc. This will allow
us to track down the people who have not been marked but have done the
tests.

The second chart will pull out people who have failed the test (the
mark is between 0 and 10). Once again, all the information should be
there.

Thank you!


--
aposatsk
------------------------------------------------------------------------
aposatsk's Profile: http://www.excelforum.com/member.php...o&userid=36709
View this thread: http://www.excelforum.com/showthread...hreadid=567129