Array Formulas

P

Peledon

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/com...dg=microsoft.public.excel.worksheet.functions
 
J

JE McGimpsey

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.
 
P

Peledon

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top