Array Formulas
Excellent, works perfect. I spent 4 hours trying to work out unsuccessfully.
I will use this site more often from now on. Big thank you.
"JE McGimpsey" wrote:
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.
|