Have you tried using the 'subtotals' command?
you can go 'data'....'subtotals' then subtotal at each change in ticket, and
subtotal the 'time'
It won't end up looking exactly as you have shown in your example but it
should do what you want it to do.


"bcamp1973" wrote:


ok, this is way over my head...maybe even impossible, but here's what
i'm trying to accomplish. I want 4 different columns as shown below.
In the "Time" and "Ticket" colums i'll track the total amount of time i
spend on any given ticket. There may be repeat entries for a ticket. In
the totals column I'd *like* it to automatically add an instance for
each unique ticket dynamically. So, even though i have ticket #123
entered 3 times, it only shows it once. To make it more difficult, i
then want to sum the time for all instances of #123 and place it in the
column to the right...does that make any sense? Hope this helps...

TIME TICKET TOTALS
------ -------- --------- -------
0:30 #123 #123 4:45
1:15 #123 #456 1:00
3:00 #123
1:00 #456
0:15 #456


--
bcamp1973
------------------------------------------------------------------------
bcamp1973's Profile: http://www.excelforum.com/member.php...o&userid=32268
View this thread: http://www.excelforum.com/showthread...hreadid=539972