Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |