Thread: Array Formulas
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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.