Sorting ranges
 

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?

--
Regards
Frank Kabel
Frankfurt, Germany
"candybox" schrieb im Newsbeitrag
...
I am trying to sort named ranges, and cannot do it. Any help would be
great

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

"candybox" wrote:

I am trying to sort named ranges, and cannot do it. Any help would be great

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.

"Peo Sjoblom" wrote:

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

"candybox" wrote:

I am trying to sort named ranges, and cannot do it. Any help would be great

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 :-)

--
Regards
Frank Kabel
Frankfurt, Germany
"candybox" schrieb im Newsbeitrag
...
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.

"Peo Sjoblom" wrote:

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

"candybox" wrote:

I am trying to sort named ranges, and cannot do it. Any help would be
great

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.

"Frank Kabel" wrote:

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 :-)

--
Regards
Frank Kabel
Frankfurt, Germany
"candybox" schrieb im Newsbeitrag
...
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.

"Peo Sjoblom" wrote:

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

"candybox" wrote:

I am trying to sort named ranges, and cannot do it. Any help would be
great

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)

--
Regards
Frank Kabel
Frankfurt, Germany
"candybox" schrieb im Newsbeitrag
...
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.

"Frank Kabel" wrote:

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 :-)

--
Regards
Frank Kabel
Frankfurt, Germany
"candybox" schrieb im Newsbeitrag
...
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.

"Peo Sjoblom" wrote:

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

"candybox" wrote:

I am trying to sort named ranges, and cannot do it. Any help would
be
great