City | Risk Level | Risk Levels | Desired | City 1 | City 2 | City 3 | City 4 | City 5 | |
Abobo | Extremely Low Risk | Extremely Low Risk | 3 | Abobo | Enderta | Raya Azebo | |||
Godere | Very High Risk | Very Low Risk | 4 | Dimma | Abergele | Mekele Special Zone | Hintalo Wajirat | ||
Dimma | Very Low Risk | Low Risk | 4 | Adwa | Mereb Lehe | Samre | Lare | ||
Gambela | Low Risk | Moderate Risk | 5 | Gambela Zuria | Degua Tembien | Alaje | Naeder Adet | Wanthou | |
Gambela Zuria | Moderate Risk | Highly Moderate Risk | 2 | Gog | Enticho | ||||
Gog | Highly Moderate Risk | High Risk | 2 | Endamehoni | Jor | ||||
Jor | High Risk | Very High Risk | 1 | Godere | |||||
Akobo | Extremely Low Risk | ||||||||
Jikawo | Very Low Risk | ||||||||
Lare | Low Risk | ||||||||
Wanthou | Moderate Risk | ||||||||
Enderta | Extremely Low Risk | ||||||||
Ofla | Very High Risk | ||||||||
Hintalo Wajirat | Very Low Risk | ||||||||
Samre | Low Risk | ||||||||
Alaje | Moderate Risk | ||||||||
Alamata | Highly Moderate Risk | ||||||||
Endamehoni | High Risk | ||||||||
Raya Azebo | Extremely Low Risk | ||||||||
Abergele | Very Low Risk | ||||||||
Adwa | Low Risk | ||||||||
Degua Tembien | Moderate Risk | ||||||||
Enticho | Highly Moderate Risk | ||||||||
Kola Tembien | High Risk | ||||||||
La'ilay Maychew | Very High Risk | ||||||||
Mek'ele | Extremely Low Risk | ||||||||
Mekele Special Zone | Very Low Risk | ||||||||
Mereb Lehe | Low Risk | ||||||||
Naeder Adet | Moderate Risk |
<colgroup><col width="106" style="width:80pt"> <col width="161" style="width:121pt"> <col width="46" style="width:35pt"> <col width="160" style="width:120pt"> <col width="64" style="width:48pt"> <col width="106" style="width:80pt"> <col width="124" style="width:93pt"> <col width="147" style="width:110pt"> <col width="142" style="width:107pt"> <col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>
Hi, I used this formula to get the desired cities randomly from the City column. However the cities desired increment by columns (horizontally) instead of by rows(Vertically). I want the cities to be added vertically. For ex:
Desired City 1 |
<tbody>
</tbody>
Enderta
Raya Azebo
This is the formula I used: =IF(COLUMNS($F2:F2)>$E2,"",INDEX($A:$A,SMALL(IF($B$2:$B$30=$D2,IF(ISNA(MATCH($A$2:$A$30,$E2:E2,0)),ROW($B$2:$B$30),0),0),RANDBETWEEN(COUNTIF($B$2:$B$30,"<>"&$D2)+COLUMNS($F2:F2),ROWS($B$2:$B$30)))))
Please let me know if there is a way to do this.
Thank you very much in advance.