Making Random Output of Cells in Excel

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
LVL 11
Eaddy BarnesITAsked:
Who is Participating?
 
Rgonzo1971Connect With a Mentor Commented:
Hi,

If you want XL to do the sorting,

pls try this

Regards
Sort-randomly.xlsx
0
 
Naresh PatelConnect With a Mentor TraderCommented:
See this link Shuffle a list on Chandoo's web site.


Thanks
0
 
Naresh PatelTraderCommented:
Fantastic  Rgonzo1971.........
0
All Courses

From novice to tech pro — start learning today.