One quick and simple way is to use autofilter on the top row where you have
the day headers: Mon, Tues ... Fri

Assume the day headers are in the top row, say in B1:F1,
(with Employee names assumed in col A, in A2 down)

Select the range, click Data Filter Autofilter

Now you could just select: Out
from the autofilter droplist in say, B1 (for Mon)
and the filtered rows in col A (Employee names)
will give you the desired results

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"YanYan" wrote in message
...
I have created an excel work schedule, it contains Columns Mon - Fri and
Rows
Employee 1 - 20. Using validation, i have created a list where only the
codes Off, On, Sick, Out, and In can be used.

I want to add a row to the bottom of my sheet that will tell me which
employee is "out". This way, instead of searching through the whole
report, I
can look at that row for each day and it will display the name of whoever
is
"out".