Thread
:
Is there an equivalent to SQLs GROUP BY?
View Single Post
#
2
Nick Hodge
Posts: n/a
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