I am working on an attendance tracker and we need to provide the names
of specific types of absences from the data entry fields on demand.
what we have is like this
A B C
1 * Agent name Reason Shift*
2 Agent 1 Tardy 0700-1530
3 Agent 2 NCNS 0700-1530
4 Agent 3 Sick 0800-1630
5 Agent 5 NCNS 0800-1630

What I need is to be able to have a result such as...

NCNS
Agent 2
Agent 5

Tardy
Agent 1

Of course we are doing it by hand now, but is there a way to get this
to do it for us?


--
NJM
------------------------------------------------------------------------
NJM's Profile: http://www.excelforum.com/member.php...o&userid=31436
View this thread: http://www.excelforum.com/showthread...hreadid=511277