G
Guest
I have a list of names and I need to be able to extract five or six names off to the side - radomly
TIA
Lacreeda
TIA
Lacreeda
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
Norman Harker
Hi Lacreeda!
One way:
Insert a helper column and in that column use =RAND() to generate a random
number.
Having generated the random numbers you can now freeze them using Copy >
Edit > Paste Special > Values
You can now use a formula to return the names:
=INDEX($A$1:$A$7,MATCH(LARGE($B$1:$B$7,ROW()),$B$1:$B$7,0),1)
I've assumed that the first name is in A1. If not, you can amend the row
argument. If the first name is in Row 5 change ROW() to ROW(A5)-4
--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
One way:
Insert a helper column and in that column use =RAND() to generate a random
number.
Having generated the random numbers you can now freeze them using Copy >
Edit > Paste Special > Values
You can now use a formula to return the names:
=INDEX($A$1:$A$7,MATCH(LARGE($B$1:$B$7,ROW()),$B$1:$B$7,0),1)
I've assumed that the first name is in A1. If not, you can amend the row
argument. If the first name is in Row 5 change ROW() to ROW(A5)-4
--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
G
Guest
Thank you, Mr. Harker. You sure my life alot easier. Thanks again.
N
Norman Harker
Hi Lacreeda!
Always pleased to help and to know something worked.
Last person who call be "Mr." sentenced me to be transported to
Australia for life; we tend to use first name terms when being polite
to each other.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Always pleased to help and to know something worked.
Last person who call be "Mr." sentenced me to be transported to
Australia for life; we tend to use first name terms when being polite
to each other.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.