Hi, I'm trying to get Excel to match information in two different columns and add the number of occurances, but unsure of how to do it.
Below I have listed 4 columns of information; I need to match for instance the number of times that in the first cell "06:15" matches the last cell "GAZ" and add the number of times this occurs, in the example it occurs "2"

Anyone that can help please?


06:15 14:45 08:30 GAZ
08:00 16:30 08:30 GEORGIA
09:00 17:30 08:30 CLAIRE
11:45 20:15 08:30 KERRY
13:45 22:15 08:30 HELEN

06:15 14:45 08:30 CLAIRE
10:00 18:30 08:30 KERRY
13:45 22:15 08:30 GAZ
17:00 22:00 05:00 PAULA

08:00 16:30 08:30 GEORGIA
08:00 16:30 08:30 HELEN
12:00 20:30 08:30 KERRY
13:45 22:15 08:30 CLAIRE
17:00 22:00 05:00 PAULA

06:15 14:45 08:30 GAZ
10:00 18:30 08:30 HELEN
13:45 22:15 08:30 CLAIRE