Solved

Making Random Output of Cells in Excel

Posted on 2014-01-21
3
243 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:greeneel
  • 2
3 Comments
 
LVL 8

Assisted Solution

by:itjockey
itjockey earned 150 total points
Comment Utility
See this link Shuffle a list on Chandoo's web site.


Thanks
0
 
LVL 48

Accepted Solution

by:
Rgonzo1971 earned 350 total points
Comment Utility
Hi,

If you want XL to do the sorting,

pls try this

Regards
Sort-randomly.xlsx
0
 
LVL 8

Expert Comment

by:itjockey
Comment Utility
Fantastic  Rgonzo1971.........
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

771 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now