| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Is there an equivalent to SQLs GROUP BY?
Yet again, I know what I want to do, but have no idea how to to it.
Say I've got Name Location Date Hours Fred Town1 1-Jan 8 Fred Town2 2-Jan 8 Fred Town1 3-Jan 10 Joe Town1 1-Jan 12 Joe Town2 2-Jan 2 etc. How can I group these on location and Name to get the result: Fred Town1 Jan 18 Fred Town2 Jan 8 Joe Town1 Jan 12 Joe Town2 Jan 2 Any suggestions? TIA J |
|
#2
|
|||
|
|||
|
J
Perfect data structure for a pivot table -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "JCP" wrote in message ... Yet again, I know what I want to do, but have no idea how to to it. Say I've got Name Location Date Hours Fred Town1 1-Jan 8 Fred Town2 2-Jan 8 Fred Town1 3-Jan 10 Joe Town1 1-Jan 12 Joe Town2 2-Jan 2 etc. How can I group these on location and Name to get the result: Fred Town1 Jan 18 Fred Town2 Jan 8 Joe Town1 Jan 12 Joe Town2 Jan 2 Any suggestions? TIA J |
|
#3
|
|||
|
|||
|
for details on using pivot tables - see www.contextures.com/tiptech.html
Cheers JulieD "Nick Hodge" wrote in message ... J Perfect data structure for a pivot table -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "JCP" wrote in message ... Yet again, I know what I want to do, but have no idea how to to it. Say I've got Name Location Date Hours Fred Town1 1-Jan 8 Fred Town2 2-Jan 8 Fred Town1 3-Jan 10 Joe Town1 1-Jan 12 Joe Town2 2-Jan 2 etc. How can I group these on location and Name to get the result: Fred Town1 Jan 18 Fred Town2 Jan 8 Joe Town1 Jan 12 Joe Town2 Jan 2 Any suggestions? TIA J |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I find the max in each group? | Excel Worksheet Functions | |||
| Can't group pivot table items by month in Excel | Excel Discussion (Misc queries) | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
| copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions | |||
| Group by count formula | Excel Worksheet Functions | |||
Linear Mode
