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

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

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