Count unique values within a hourly time range

[legend2009]

Hello,

I need to count how many unique "operator codes" are active within certain intervals throughout the day. I do not want to use a pivot table. I've failed trying to adapt similar formulas for date ranges. Any ideas? Sample data is below. For example, for time range 7:00 to 8:00 AM, there are 5 rows but only 3 unique "operator codes".

Arrival Time	Operator
2:30 PM	BBB
9:47 AM	BBB
6:45 AM	AAA
7:34 AM	BBB
7:47 AM	AAA
7:50 AM	BBB
7:32 AM	BBB
2:27 PM	AAA
2:32 PM	AAA
7:45 AM	CCC
8:45 AM	BBB
2:37 PM	AAA

<tbody>
</tbody>

 

[legend2009]

Just figured it out. Here is an example formula for anyone looking later:

=SUM(IF(FREQUENCY(IF(A1:A9>=TIME(7,0,0),IF(A1:A9<=TIME(8,0,0),MATCH("~"&B1:B9,B1:B9&"",0))),ROW(B1:B9)-ROW(B1)+1),1))

My times are in column A and the data is in column B.

This does require CTRL - SHIFT - ENTER.