Sorting data

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I have a data set of 12 columns with 200 unique codes in Column A.
I would like to be able to automatically create subtotals for each of the
data columns sorted by Column A data.

Easy to do manually but don't know how to do automatically.
 
Chris
I believe that the simplest method is to sort on column A after highlighting
all your columns and rows containg data.
I assume each column has a heading !
Again, highlight ALL your data,
then - Data > Subtotals and complete the boxes in the window : At each
change in 'a'
Use function 'sum'
Add sub totals to - tick column letters that you wish to sub total
Tick 'Summary below data' will give you a Grand Total
Click 'OK'
Hope this helps
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting data with a formula 4
Additonal info into newly created Subtotal row 1
Sorting day names chronologically 5
2 dimensional date sort 1
Automatic Sorting? 6
Showing data unigue to multiple columns in a pivot table 1
combining data from multiple worksheets into one 6
Help with Macro for sorting 2

Back
Top