Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Randomly sorting the alphabet
I have tried the suggestions on random sorting and it's just not working.
Each time I type in =RAND() in the 'helper' column, that's all I get, repeated in each cell. When I sort, nothing happens!! Please help, I'm trying to complete a calendar that has the letters of the alphabet sorted randomly on it for bus transfers. thanks ever so much -- Lydia Wehrli |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Randomly sorting the alphabet
Format the column as general, then apply the formula and copy it down
-- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "lydiaw1" wrote in message ... I have tried the suggestions on random sorting and it's just not working. Each time I type in =RAND() in the 'helper' column, that's all I get, repeated in each cell. When I sort, nothing happens!! Please help, I'm trying to complete a calendar that has the letters of the alphabet sorted randomly on it for bus transfers. thanks ever so much -- Lydia Wehrli |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Randomly sorting the alphabet
It was already formatted as general, when I click on formula and select RAND,
I get an error message that says the formula is 'volatile' and then the cell that had the formula in it shows a number in it and the letter I typed there goes away. I'm just not technical enough to figure out how to do this. I just need someone who can take me step by step....a couple of years ago someone had spelled this out clearly and I can't find that persons response anymore. Thanks anyways -- Lydia Wehrli "Peo Sjoblom" wrote: Format the column as general, then apply the formula and copy it down -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "lydiaw1" wrote in message ... I have tried the suggestions on random sorting and it's just not working. Each time I type in =RAND() in the 'helper' column, that's all I get, repeated in each cell. When I sort, nothing happens!! Please help, I'm trying to complete a calendar that has the letters of the alphabet sorted randomly on it for bus transfers. thanks ever so much -- Lydia Wehrli |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting Sorting Sorting | Excel Discussion (Misc queries) | |||
Column picked randomly with probability relative to number of entr | Excel Worksheet Functions | |||
Trouble Sorting Averages of Randomly Generated Numbers | Excel Discussion (Misc queries) | |||
SORTING question | New Users to Excel | |||
Adding a KeyID column for sorting | New Users to Excel |