Frequency table?

**tessda** · 07-01-2012, 04:43 PM

Hi friends,

I have two tables consisting of a stop to stop demand matrix for 30 stops (in the top table the demand between station 2 and 6 is 18passengers) and another providing the distances between these stops (in the bottom table the distance between stop 2 and 6 is 1.69km) (see the example attached). I would like to compile a summary of the data in these tables and wondered whether a sort of a "frequency table" can be compiled or whether another formula should be used to arrive at the result. The result must be a table summarising the distances between the stops and the number of passengers traveling these distances as summarised in the "Result required" at the bottom of the two tables.

Can anybody assist in sorting out this problem.

Regards

Dan

**Special-K** · 07-01-2012, 06:03 PM

There is no "Result required" anywhere in your spreadsheet

**tessda** · 07-02-2012, 01:23 AM

EXAMPLE DEMAND 1.xlsxHi Special-K,

I apologise for not including the table. Attached is the revised spreadsheet.

Hope you or anyone on the forum can assist.

Regards