» Shuffling a List of Values

Problem:

List1 (column B) contains a range of alphabetically sorted letters.
We want to create a randomly shuffled list of the same letters in column C.

Solution:

Enter the RAND function as shown in each of the corresponding cells in column A:
=RAND()
In column C, use the VLOOKUP, LARGE, and ROW functions as shown in the following formula:
=VLOOKUP(LARGE($A$2:$A$9,ROW()-ROW($C$2)+1),$A$2:$B$9,2,FALSE)
The list will reshuffle with each recalculation ( key).

Book Store:

• Excel VBA books
• Accounting books
• Business Plans
• MS Office books
• Taxes books

VIEW ALL BOOKS

Recommended Books:

• Writing Excel Macros with VBA, 2nd Edition
• Real Estate Loopholes: Secrets of Successful Real Estate Investing
• Word 2002: The Complete Reference
• What the IRS Doesn't Want You to Know: A Cpa Reveals the Tricks of the Trade
• The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
• Absolute Beginner's Guide to Microsoft Office Excel 2003

Email Tip

Print Tip

Add to My Tips

Rate This Tip

1 2 3 4 5

Rating: 5.00     Views: 8474

No comments have been submitted.

Name

Comment Title

Comments