Array Formulas
 

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.


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

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.

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.