Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 315
  • Last Modified:

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
0
Eaddy Barnes
Asked:
Eaddy Barnes
  • 2
2 Solutions
 
Naresh PatelTraderCommented:
See this link Shuffle a list on Chandoo's web site.


Thanks
0
 
Rgonzo1971Commented:
Hi,

If you want XL to do the sorting,

pls try this

Regards
Sort-randomly.xlsx
0
 
Naresh PatelTraderCommented:
Fantastic  Rgonzo1971.........
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now