Random list of names in table

**kazie** · 04-17-2010, 12:35 PM

hello, I am a new member, I hope someone can help me about the use of formula in the table

1. I have a list of names using the text code of 50 listings. I want to list the code shown in the table is random. . I only want 26 list of the names of 50. Each code is only displayed once per columm.

I enclose herewith the excel file,

I hope someone can show me how to use the formula for this problem.

thank

**shg** · 04-17-2010, 12:54 PM

In A3 and copy down, =RAND()

Then sort by colums A and B by col A and choose the top 26 results.

**kazie** · 04-17-2010, 02:00 PM

Originally Posted by shg

In A3 and copy down, =RAND()

Then sort by colums A and B by col A and choose the top 26 results.

thank you on your guide. I'm confused how to list coded list can be displayed at each table colum. I hope you can see the files I attached, so you have some idea of what I mean.

I hope you can give a formula in my file to include.

thank you for your guidance

**martindwilson** · 04-17-2010, 02:33 PM

or if you want to generate it automatically(not sure which list you mean )then use a combination of rand(),unique rank(there is a small chance of rand() returning the same value so its best to rank) and index /match
see sheet name list for the principle