In case you might be interested in also creating a list of "Tardy", say you
enter the date of interest in CB1, and in CB2 you enter your "A" for absent,
or "T" for tardy, or whatever.
Then enter this *array* formula in CB3, and copy down enough rows to insure
that all possible names are returned.
You'll get a #NUM! error when the formula runs out of names to find.

=INDEX($A$2:$A$50,SMALL(IF(($B$1:$CA$1=$CB$1)*($B$ 2:$CA$50=$CB$2),ROW($A$1:$
A$49)),ROWS($1:1)))

--
Array formulas are entered using CSE, <Ctrl <Shift <Enter, instead of the
regular <Enter, which will *automatically* enclose the formula in curly
brackets, which *cannot* be done manually.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"CJ-22" wrote in
message ...

Hi,

I am new to array formulas, but so far I am thoroughly impressed with
what they can do. I am stuck right now on one and was hoping for some
help. I am a teacher and I keep daily records of my students on excel.
My daily record spreadsheet is similar to this:

Row 1 - Dates for each school day
Column A - Student Names
B2:CA50 - Daily Record keeping such as absence, tardy, homework, etc.

What I want is a column that will list all absences for a specific day.
In other words, have a cell where I can input any date and a list would
generate for all the students absent on that date. The formula would
need to search row 1 for the date, find all "A"s in the column of that
date, and return the name in column A. Can this be done?

Thanks for any replies.

CJ-22


--
CJ-22
------------------------------------------------------------------------
CJ-22's Profile:
http://www.excelforum.com/member.php...o&userid=17551
View this thread: http://www.excelforum.com/showthread...hreadid=506632