I think a Pivot Table would be the easiest approach, but since you
prefer the formulas...See if this works for you:

In the example I previously posted, the formula in D2 calculates the
total time in Col_A where the Col_B value matches C2. For that
approach to work for all unique Col_B values, you'd need a list of
those values. I'd use an Advanced Filter to build that list:

C1: TICKET (the same value as B1)
Select your data in columns A and B, including the column titles in
Row_1.

<data<filter<advanced filter
Check: Copy to another location
Check: Unique records only
List Range: (your already selected data)
Criteria Range: (leave this blank)
Copy To: $C$1
Click [OK]

That will create a list of unique Col_B values under C1

Now, copy the previously posted D2 formula down as far as you need it.

Does that help?

Regards,
Ron


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