Thread
:
Is there an equivalent to SQLs GROUP BY?
View Single Post
#
3
JulieD
Posts: n/a
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 With Quote