• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 446
  • Last Modified:

Problem with sort in Excel 2010

I have a worksheet that has three sections of data on it.  The sections are separated by rows.  I want to sort the top section by the last column in that section.  I select the range (A13:AE28), then right click the range and choose sort/custom sort.  I deselect the headers option because there are three levels of headers so I only want to select the range.  Then I choose sort by column AE.  Then I choose sort largest to smallest.  Column AE contains numbers.  It seems simple enough but when I click sort the only column in the range that ends up sorted is column AE -- not the entire range.  Am I missing a step?  This happens if I code the sort also.  I eventually want to code the sort and attach it to a click event but I can't even get the sort to work properly by doing it manually.
0
dkcoop03
Asked:
dkcoop03
  • 4
  • 3
1 Solution
 
Patrick MatthewsCommented:
dkcoop03,

It would be useful to see some sample data and/or a sample file.  EE now allows you to directly upload files to your question.

Please be advised that once you upload a file, it can be publicly accessed, and that it may not be possible to fully and permanently delete it.  The file may also be indexed by the major search engines.

Therefore, be very careful about posting proprietary, confidential, or other sensitive information.  If necessary, use "fake" and/or obfuscated data in your sample.

Please note that at present EE restricts uploads to certain file types.  If your file type does not match those in the list, you can use http://www.ee-stuff.com instead, which is not officially an EE site, but is run by people connected to EE.

Patrick
0
 
Paul SauvéCommented:
When you select ONLY the column, Excel gives you a choice to sort onlu the selected column OR to select ALL columns of the selected range! Select Sort Select Option: Expand the selection
0
 
Paul SauvéCommented:
OR select all the columns in the desired range...
0
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 
dkcoop03Author Commented:
It's difficult for me to attach an example since the entire sheet is made up of vlookups to another sheet.  I'm wondering if this is the problem.  BTW...Paulsauve...I did select all columns in the desired range.  The only column that sorted was the column that I specified in the first level.  

Anyway, if I copy the section and do a PASTE SPECIAL VALUES to another sheet and then select the all columns in the range  -- do a custom sort -- and select the correct column it sorts just fine.  Is there a problem with sorting calculated columns?

I'm still trying to get some kind of example.
0
 
dkcoop03Author Commented:
I'm attaching a sample spreadsheet.  I am trying to select by column AE.  The range I select is A13:AE22.  Then I click Sort/Custom Sort and choose no headers and sort by column AE.  The columns to the left of column AE do not get sorted along with column AE.  Thanks for any help.
Copy-of-testdoc.xlsm
0
 
dkcoop03Author Commented:
A little more information...There are multiple sheets in the workbook where this sheet is located.  I've sorted another sheet that is formatted similarly without any problem so I can't figure out what could be wrong.  
0
 
Paul SauvéCommented:
Well - you're correct - the cells with formulae do NOT get sorted - and I don't think I have an answer for you.
0
 
dkcoop03Author Commented:
I might have to talk with MS about this one
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now