Lookup to find multiple occurrences

Hi and thanks for taking the time to read,

I have been given a series of spreadsheets output from an attendance system and I need to identify how many people started at given times each day during the year (there are multipe years).

I know I can't use VLOOKUP as this will only find the first occurance; I think that a mix of INDEX, MATCH, LOOKUP and probably a couple of others might do the trick but, to date, I just can't get me head around arrays and match & index.

I'm sure it's an easy formula for most people ... just that I'm a bit thick! Can someone help, please?

I've added a sample to help explain (including the hoped for output

Put 05:45 in cell A25 (or copy it from a cell that has that value), and then you can have this formula in B27:

=COUNTIFS(B$2:B$23,$A$25,$A$2:$A$23,$A27)

You can copy that across to H27 and then down to row 30.

Then you can put 06:45 in A32, and this formula in B34:

=COUNTIFS(B$2:B$23,$A$32,$A$2:$A$23,$A34)

and copy that across and down for the next block, and so on.

Hope this helps.

Pete

Many thanks - I need to spend a bit of time on Youtube to fully understand this but the Pivot Table option seems really good (even though my skills are being pushed!)