Array Formulas
One way:
Create a Pivot Table, with Count of Weight in the Data region, City and
Date in the Rows region, and Weight in the Columns Region. RIght-click
the Weight field in the columns region and choose Group and
Outline/Group. In the dialog, use Starting at 0, Ending at 30, By 15.
In article ,
Peledon wrote:
I would like to count how many lorries leave each city with <15t and a
separate column 15t for each date.
Date City Weight
11-Feb Omsk 25
12-Feb Omsk 20
12-Feb Tobolsk 5
13-Feb Omsk 12
13-Feb Omsk 12
Can anyone help.
|