Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
array formulas | Excel Worksheet Functions | |||
IF statement in Array Formula's | Excel Discussion (Misc queries) | |||
array formulas disabled? | Excel Worksheet Functions | |||
array formulas | Excel Worksheet Functions | |||
array formulas | Excel Worksheet Functions |