# Random names from short list

J

#### Jose Lopes

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?)

M

#### Mike H

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

J

#### Jose Lopes

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

J

#### Jose Lopes

Hi again.

After a search I found out that RANK translates to ORDEM. Problem solved.

Thx again