muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,077
- Office Version
- 365
- 2021
- Platform
- Windows
hi all...
i have problem how to make data validation list/formula with multiple criteria
<tbody>
</tbody>
expected result :
<tbody>
</tbody>
- when i select Inner City , in the cell adjacent possible in Model show I, II, IIIA, IIIB, IIIC...then i select I ....shown Arteri..
please, don't use vba/macro.
any help is greatly appreciated....
m.susanto
i have problem how to make data validation list/formula with multiple criteria
City | Model | Type |
---|---|---|
Inner City | I | Arteri |
Inner City | II | Arteri |
Inner City | IIIA | Arteri |
Inner City | IIIA | Kolektor |
Inner City | IIIB | Kolektor |
Inner City | IIIC | Jalan Lokal |
Outer City | I | Arteri Primer |
Outer City | I | Kolektor Primer |
Outer City | I | Arteri Sekunder |
Outer City | II | Kolektor Primer |
Outer City | II | Arteri Sekunder |
Outer City | II | Kolektor Sekunder |
Outer City | IIIA | Kolektor Sekunder |
Outer City | IIIA | Jalan Lokal |
Outer City | IIIB1 | Jalan Lokal/Parkir |
Outer City | IIIB2 | Jalan Lokal/Parkir |
Outer City | IIIC | Jalan Lokal/Parkir |
<tbody>
</tbody>
expected result :
Data Validation | ||
---|---|---|
City | Model | Type |
Inner City | IIIA | Arteri |
Kolektor | ||
Ineer city | I | Arteri |
Ineer city | IIIB | Kolektor |
<tbody>
</tbody>
- when i select Inner City , in the cell adjacent possible in Model show I, II, IIIA, IIIB, IIIC...then i select I ....shown Arteri..
please, don't use vba/macro.
any help is greatly appreciated....
m.susanto
Last edited: