software

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: www.excelforum.com/member.php...oamp;userid=31436
View this thread: www.excelforum.com/showthread...hreadid=511277Sounds like you could just sort as First Key on the Reason column and Second
Key on the AgentName column.....

Vaya con Dios,
Chuck, CABGx3quot;NJMquot; gt; wrote in message
...
gt;
gt; I am working on an attendance tracker and we need to provide the names
gt; of specific types of absences from the data entry fields on demand.
gt; what we have is like this
gt; A B C
gt; 1 * Agent name Reason Shift*
gt; 2 Agent 1 Tardy 0700-1530
gt; 3 Agent 2 NCNS 0700-1530
gt; 4 Agent 3 Sick 0800-1630
gt; 5 Agent 5 NCNS 0800-1630
gt;
gt; What I need is to be able to have a result such as...
gt;
gt; NCNS
gt; Agent 2
gt; Agent 5
gt;
gt; Tardy
gt; Agent 1
gt;
gt; Of course we are doing it by hand now, but is there a way to get this
gt; to do it for us?
gt;
gt;
gt; --
gt; NJM
gt; ------------------------------------------------------------------------
gt; NJM's Profile:
www.excelforum.com/member.php...oamp;userid=31436
gt; View this thread: www.excelforum.com/showthread...hreadid=511277
gt;

Actually, I need more than just a sort. I need this to populate to a
seperate set of cells/worksheet. HR makes us leave our input fields
alone once they are entered, but we need to coalate the data for
department reports.--
NJM
------------------------------------------------------------------------
NJM's Profile: www.excelforum.com/member.php...oamp;userid=31436
View this thread: www.excelforum.com/showthread...hreadid=511277Here's a proposal:

tardyNCNSsickdon't know
tardyagent 6tardy2 agent 1agent 2agent 3agent 5
don't kagent 5don't k1 agent 6agent 4
NCNSagent 4NCNS2
sickagent 3sick1
NCNSagent 2NCNS1
tardyagent 1tardy1Arrange your data as follows:

Reason for absence in Column A
Agent name in column B
sort A:B by agent name descending
in C2 type this formula: =A2amp;COUNTIF(A2:A$7;quot;=quot;amp;A2)
copy down to the last row of your data
In D1 type the first reason for absence and continue with the next in E
and further to the right
In D2 type this formula:
=IF(ISNA(MATCH(D$1amp;ROW(D2)-ROW($D$2) 1;$C$2:$C$7;0));quot;quot;;OFFSET($B$2;MATCH(D$1 amp;ROW(D2)-ROW($D$2) 1;$C$2:$C$7;0)-1;0))
You may have to replace the semicolons with commas depending on your
local Windows settings for regional and language
Copy D2 down as many rows as you expect agentt names
Copy all formulas in D to the right as required

Hope this does it for you.

HansThen perhaps just sort or AutoFilter the main database, and then just copy
it over to another worksheet....then you can manipulate that new sheet at
will without distrubing the main database.....this can be done either by
hand, or by macro if the sorting/filtering requirements are always the
same............

Vaya con Dios,
Chuck, CABGx3quot;NJMquot; gt; wrote in message
...
gt;
gt; Actually, I need more than just a sort. I need this to populate to a
gt; seperate set of cells/worksheet. HR makes us leave our input fields
gt; alone once they are entered, but we need to coalate the data for
gt; department reports.
gt;
gt;
gt; --
gt; NJM
gt; ------------------------------------------------------------------------
gt; NJM's Profile:
www.excelforum.com/member.php...oamp;userid=31436
gt; View this thread: www.excelforum.com/showthread...hreadid=511277
gt;