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

C

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
 
E

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.
 
B

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.
 
Top