Sorting ranges

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to sort named ranges, and cannot do it. Any help would be great
 
Hi
what exactly is not possible? Do you get an error message, etc?
 
Can you be more specific, what can't you do? Or rather what do you excpect to
happen, what happens and how did you do it?

Regards,

Peo Sjoblom
 
I have data in a bunch of different cells, but it is all attached to one
number, which is listed in column A. I have selected the data and given it a
range name. What I would like to do is sort the named ranges, so that all
the cells in the named range stay together.
 
Hi
does that mean you have for example in A1 a name and in B1:B10 associated
data?. Please try to be a little bit more specific. We don't know your file.
We don't know what a 'bunch of cells ' really is :-)
 
I have a number in A1 name in B1 & C1; list of data in D2:D7; list of data in
E2:E11. Then the same thing starts at A13; B13 & C13 etc.
 
Hi
now I see. Problem: Excel's sort function can't sort such data setup. It
requires a database table like setup (that is one row per record)
 
You must log in or register to reply here.

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

range definition by cells numbers 3
Set non-continuous PrintArea via Function / Name 0
Pivot Table Sorting 6
Data Sorting 1
sort part of a filtered spreadsheet 1
New printer recommendations 2
Link to a named range in another worksheet that is sorted frequent 2
writing a sort macro 2

Back
Top