Is there an equivalent to SQLs GROUP BY?

  • Thread starter Thread starter JCP
  • Start date Start date
J

JCP

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
(e-mail address removed)
 
Back
Top