Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Random pick a city name from the list until it reaches a certain number of names

0

Hi, I am trying to pick random city names from a list, the data has different categories. I want to pick 23 city names randomly (3 from extremely low risk, 4 from very low risk, 4 from low risk, 5 from moderate risk, 2 from highly moderate risk, 2 from high risk and 1 from very high risk.

City                    Risk Level

AboboExtremely   Low Risk

GodereVery          High Risk

DimmaVery           Low Risk

Gambela                Low Risk

Gambela Zuria        Moderate Risk

GogHighly               Moderate Risk

Jor                           High Risk

AkoboExtremely       Low Risk

JikawoVery               Low Risk

Lare                         Low Risk

Wanthou                   Moderate Risk

EndertaExtremely    Low Risk

OflaVery                   High Risk

Hintalo WajiratVery   Low Risk

Samre                       Low Risk

Alaje                          Moderate Risk

AlamataHighly           Moderate Risk

Endamehoni              High Risk

Raya AzeboExtremely   Low Risk

AbergeleVery                 Low Risk

Adwa                              Low Risk

Degua Tembien               Moderate Risk

EntichoHighly                 Moderate Risk

Kola Tembien                    High Risk

La'ilay MaychewVery           High Risk

Mek'eleExtremely                  Low Risk

Mekele Special Zone          Very Low Risk

Mereb Lehe                           Low Risk

Naeder Adet                          Moderate Risk

Any help or suggestion will be very helpful. Thank you so much in advance. 

Answer
Discuss

Discussion

How about this...have another column called Random that generates a random number ,=rand(), then sort the table by Risk Level and then Random. 
gebobs (rep: 30) May 16, '17 at 2:38 pm
gebobs, I think you should put that as an Answer! It is a perfect solution that just about anyone can follow.
don (rep: 1989) May 17, '17 at 8:19 am
Dokey okes.
gebobs (rep: 30) May 17, '17 at 9:24 am
Add to Discussion

Answers

0

How about this...have another column called Random that generates a random number ,=rand(), then sort the table by Risk Level and then Random. 

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login