?
Solved

Making Random Output of Cells in Excel

Posted on 2014-01-21
3
Medium Priority
?
303 Views
Last Modified: 2014-01-22
Ok experts,

I used the =A1 & " " &text(B1,"$#,#0.00") formulae in cell D1 to combine cells A1 & B1

Now i'm wondering if its possible to:

1. Make cells D1 all the way through to D17 appear in cell F1 through F17 listing randomly

I have attached an example..


Thanks in advance
Untitled2.jpg
0
Comment
Question by:Eaddy Barnes
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 8

Assisted Solution

by:Naresh Patel
Naresh Patel earned 600 total points
ID: 39799179
See this link Shuffle a list on Chandoo's web site.


Thanks
0
 
LVL 52

Accepted Solution

by:
Rgonzo1971 earned 1400 total points
ID: 39799187
Hi,

If you want XL to do the sorting,

pls try this

Regards
Sort-randomly.xlsx
0
 
LVL 8

Expert Comment

by:Naresh Patel
ID: 39799190
Fantastic  Rgonzo1971.........
0

Featured Post

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question