GROUP BY using Excel Worksheets

[t16turbo]

Hi there,

is it possble to perform the equivalent of an SQL GROUPB-BY in Excel?

I have a large range of data, and in column B a code is populated.
I will need to sum all of column I, for each code in Column B.

I don't want the results like the subtotals in Excel, as I was hoping for a new worksheet with one row for each code..

any ideas/suggestions?

thanks in advance

 

[PHV]

You may use MS-Query (menu Data -> External data -> New query ...) to read your large range of data with an aggregate query.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[RonRepp]

I've used ADO to perform this in the past; however, I was using it from VB6, not VBA. To get the correct syntax for an Excel ADO, go to

http://www.connectionstrings.com/

I hope this helps.

Ron

Ron Repp

 

[teethofgold]

I suggest using a pivot table.