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

Thx in advance
 
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
info about functions and languages?
 
J

Jose Lopes

Hi again.

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

Thx again
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unique Rank with Duplicate Entries 6
copy & pasting automatic formulas 3
Selecting more cells than I want 6
Index Match Between 3 Sheets 3
link text cells on different sheets 3
How can I convert many rows of hyperlinks to BASE links? 1
IF function to return date content of another cell 7
=NameCheck - Monday??? 3

Top