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

[Claude38]

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

[Earl Kiosterud]

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" <[email protected]> wrote in message
news:[email protected]...
> 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]

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.

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" <[email protected]> wrote in message
news:[email protected]...
> 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