HOW DO I SORT NAMED CELLS ? (the name stays in the original place)
 

Hello,

I have an array of cells containing questions and answers. I want to
present those question in a different order every time. So I generate a list
of random numbers associated with the question-answer duets and I use those
numbers to change the order when I need to. But for future processing, each
answer cell has a name, and the name stays in its original place after
sorting, which seems strange to me.

Is there a way around this problem ?

Thanks for helping.
Claude

Claude,

Sorting effectively copies cells, not moves cells, something most apparent
when you have formulas in the table that's been sorted, but also with range
names -- they stay put. Perhaps you can use a name column instead of range
names.
--
Earl Kiosterud
www.smokeylake.com

"Claude38" wrote in message
...
Hello,

I have an array of cells containing questions and answers. I want to
present those question in a different order every time. So I generate a
list
of random numbers associated with the question-answer duets and I use
those
numbers to change the order when I need to. But for future processing,
each
answer cell has a name, and the name stays in its original place after
sorting, which seems strange to me.

Is there a way around this problem ?

Thanks for helping.
Claude

Claude,

Sorting moves cell contents, not cells, but for your problem you could
move the name to the column before the answer (ie, don't use the 'Name'
feature, put a name in a cell) and use
=Match("required-name",D:D,1)
for names in column D to return to you the row number for your
answer.
I don't think the Match likes to find numbers even if described as
text, but 'label9' etc works ok.

Assuming that the answers are in culumn E and the 'Match' is in cell
F1,
=Indirect("E"&F1)
should provide the answer you need.


Earl Kiosterud Wrote:
Claude,

Sorting effectively copies cells, not moves cells, something most
apparent
when you have formulas in the table that's been sorted, but also with
range
names -- they stay put. Perhaps you can use a name column instead of
range
names.
--
Earl Kiosterud
www.smokeylake.com

"Claude38" wrote in message
...
Hello,

I have an array of cells containing questions and answers. I want
to
present those question in a different order every time. So I
generate a
list
of random numbers associated with the question-answer duets and I
use
those
numbers to change the order when I need to. But for future
processing,
each
answer cell has a name, and the name stays in its original place
after
sorting, which seems strange to me.

Is there a way around this problem ?

Thanks for helping.
Claude


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=395565