muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,077
- Office Version
- 365
- 2021
- Platform
- Windows
hi all..
i have the data this below :
<thead>
</thead><tbody>
</tbody>
my problem in column type :
if Inner---drop down list show I, II, IIIA, IIIB then if IIIA--drop down list show ONLY Arteri, Kolektor
i want to make data validation with unique list (drop down) based on adjacent columns
any help, thanks in advance..
.sst
i have the data this below :
Group | Class | Type |
---|---|---|
Inner | I | Arteri |
Inner | II | Arteri |
Inner | IIIA | Arteri |
Inner | IIIA | Kolektor |
Inner | IIIB | Kolektor |
Inner | IIIC | Jalan Lokal |
Outer | I | Arteri Primer |
Outer | I | Kolektor Primer |
Outer | I | Arteri Sekunder |
Outer | II | Kolektor Primer |
Outer | II | Arteri Sekunder |
Outer | II | Kolektor Sekunder |
Outer | IIIA | Kolektor Sekunder |
Outer | IIIA | Jalan Lokal |
Outer | IIIB1 | Jalan Lokal/Parkir |
Outer | IIIB2 | Jalan Lokal/Parkir |
Outer | IIIC | Jalan Lokal/Parkir |
<thead>
</thead><tbody>
</tbody>
my problem in column type :
if Inner---drop down list show I, II, IIIA, IIIB then if IIIA--drop down list show ONLY Arteri, Kolektor
i want to make data validation with unique list (drop down) based on adjacent columns
any help, thanks in advance..
.sst
Last edited: