Counting the frequency of occurence of 3 variables

[abberyfarm]

Hi,

I have 3 Columns of data covering about 20,000 rows. For example

Sheet1

*	A	B	D
1	Start Time	Distance	Journey Time
2	08:00:00	9.5	22
3	17:45:00	10	28
4	08:00:00	9.5	24
5	17:30:00	9.5	34
6	08:15:00	9.5	28
7	14:00:00	3	14
8	15:30:00	10	24

How could I count up the number of occurrences of each combination?

For example I want it to check all the rows and if the first combination occurs 3 time then put 3 in the frequency column.

Excel Workbook
	A	B	D	E	F
1	Start Time	Distance	Journey Time		Frequency
2	08:00:00	9.5	22		3
Sheet1

Would you use a pivot table? What labels would go in the different fields?

Thank you

 

[njimack]

Yes, use a pivot table:
Row labels: Start Time; Distance; Journey Time
Values: Count of Journey Time

 

[abberyfarm]

Hi Neil,

Thank you for your reply. I can't seem to get this to work. The table is not making sense. Would you mind having a look at my workbook?

https://dl.dropbox.com/u/54057365/All/Example wb forum.xlsx

I would really appreciate the help.

John