Hi. I did search the messages, and could not find what I was looking for.

I am using Excel as a rollbook for all my classes. The dates go across and
the names go down.
I have it adding up all the A's and T's so I can see the totals of how many
times Absent and Tardy by using CountIf.

What I want it to do is give me a summary of which days exactly they were
absent.

So here is what it looks like...
Row 1 is the headers and dates
Row 2 column G is their names... From H3:DD26, I have the grids where I type
in an A or a T.
Right now in columns A:F, I have it adding up how many A's and T's they have
for each quarter, and totals.

What I want it to do is to give me a list of the dates they were absent
(marked by an A). When I try the lookup, it only gives me the first one it
finds. I want all of the dates they were absent to show up.

I figured I'd have to put this below the current range (in row 28 or below).
And, I'd like the dates to go across the row and tell me what the date of
their A's are.

Make sense?? Reply if you need more info!