Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Random names from short list
Ive seen some posts here about what Im trying to achieve and still Im not
able do it. I have a list of only 7 workers. I need to reorder them randomly in another column. Ive tryied to use a formula Ive seen here =INDEX($A$1:$A$65,RANK(B1,$B$1:$B$65)) But Im still getting duplicate names and #N/D errors. Ive tryied to analyse the cause with no success. Can it be because Im using all the seven names list? By the way... my language is Portuguese and I think the function RANK relates to the CORRESP formula right? (by the way, how can I convert formulas from english to other languages?) Thx in advance |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Random names from short list
Hi,
In my best Portuguese, try this =Rand() in B1 and drag down to the same length as your names Put this in another column and drag down 7 rows =INDEX($A$1:$A$7,RANK(B1,$B$1:$B$7)) Tap F9 and you wil get you 7 names randomely ordered Mike "Jose Lopes" wrote: Ive seen some posts here about what Im trying to achieve and still Im not able do it. I have a list of only 7 workers. I need to reorder them randomly in another column. Ive tryied to use a formula Ive seen here =INDEX($A$1:$A$65,RANK(B1,$B$1:$B$65)) But Im still getting duplicate names and #N/D errors. Ive tryied to analyse the cause with no success. Can it be because Im using all the seven names list? By the way... my language is Portuguese and I think the function RANK relates to the CORRESP formula right? (by the way, how can I convert formulas from english to other languages?) Thx in advance |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Random names from short list
Hi Mike, thank you for your fast reply but I still have the same result over
here. Still with duplicate numbers and #N/D errors. But in my best Portguese Im almost 100% certain that the INDEX function is INDICE but by the looks of it Im doubting that RANK is CORRESP Where can I search any info about functions and languages? "Mike H" wrote: Hi, In my best Portuguese, try this =Rand() in B1 and drag down to the same length as your names Put this in another column and drag down 7 rows =INDEX($A$1:$A$7,RANK(B1,$B$1:$B$7)) Tap F9 and you wil get you 7 names randomely ordered Mike "Jose Lopes" wrote: Ive seen some posts here about what Im trying to achieve and still Im not able do it. I have a list of only 7 workers. I need to reorder them randomly in another column. Ive tryied to use a formula Ive seen here =INDEX($A$1:$A$65,RANK(B1,$B$1:$B$65)) But Im still getting duplicate names and #N/D errors. Ive tryied to analyse the cause with no success. Can it be because Im using all the seven names list? By the way... my language is Portuguese and I think the function RANK relates to the CORRESP formula right? (by the way, how can I convert formulas from english to other languages?) Thx in advance |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Random names from short list
Hi again.
After a search I found out that RANK translates to ORDEM. Problem solved. Thx again "Mike H" wrote: Hi, In my best Portuguese, try this =Rand() in B1 and drag down to the same length as your names Put this in another column and drag down 7 rows =INDEX($A$1:$A$7,RANK(B1,$B$1:$B$7)) Tap F9 and you wil get you 7 names randomely ordered Mike "Jose Lopes" wrote: Ive seen some posts here about what Im trying to achieve and still Im not able do it. I have a list of only 7 workers. I need to reorder them randomly in another column. Ive tryied to use a formula Ive seen here =INDEX($A$1:$A$65,RANK(B1,$B$1:$B$65)) But Im still getting duplicate names and #N/D errors. Ive tryied to analyse the cause with no success. Can it be because Im using all the seven names list? By the way... my language is Portuguese and I think the function RANK relates to the CORRESP formula right? (by the way, how can I convert formulas from english to other languages?) Thx in advance |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Random names from short list
http://dolf.trieschnigg.nl/excel/excel.html
http://cherbe.free.fr/traduc_fonctions_xl97.html (& http://cherbe.free.fr/fonctions_XL.ZIP) http://www.oaltd.co.uk/DLCount/DLCou...enuFunDict.zip from http://www.oaltd.co.uk/mvp/ and various other places. -- David Biddulph "Jose Lopes" wrote in message ... Hi Mike, thank you for your fast reply but I still have the same result over here. Still with duplicate numbers and #N/D errors. But in my best Portguese I'm almost 100% certain that the "INDEX" function is "INDICE" but by the looks of it I'm doubting that "RANK" is "CORRESP". Where can I search any info about functions and languages? "Mike H" wrote: Hi, In my best Portuguese, try this =Rand() in B1 and drag down to the same length as your names Put this in another column and drag down 7 rows =INDEX($A$1:$A$7,RANK(B1,$B$1:$B$7)) Tap F9 and you wil get you 7 names randomely ordered Mike "Jose Lopes" wrote: I've seen some posts here about what I'm trying to achieve and still I'm not able do it. I have a list of only 7 workers. I need to reorder them randomly in another column. I've tryied to use a formula I've seen here =INDEX($A$1:$A$65,RANK(B1,$B$1:$B$65)) But I'm still getting duplicate names and #N/D errors. I've tryied to analyse the cause with no success. Can it be because I'm using all the seven names list? By the way... my language is Portuguese and I think the function RANK relates to the CORRESP formula right? (by the way, how can I convert formulas from english to other languages?) Thx in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create a random list of names from a list of names in EXCEL | Excel Worksheet Functions | |||
random pick names from the list | Excel Discussion (Misc queries) | |||
list names in random order in Excel 2002 | Excel Discussion (Misc queries) | |||
I can't save long file names, only short one, how can I do this? | Excel Discussion (Misc queries) | |||
Setting up a random list from long list of names ? | Excel Discussion (Misc queries) |