Data Validation With Unique Drop Down List

[muhammad susanto]

hi all..

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

 

[muhammad susanto]

hope make clear that i want it..based my post before
<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC ;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC ;
}
.tableizer-table th {
background-color: #104E8B ;
color: #FFF ;
font-weight: bold;
}
</style><style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC;
}
.tableizer-table th {
background-color: #104E8B;
color: #FFF;
font-weight: bold;
}
</style>
<table class="tableizer-table">
<thead><tr class="tableizer-firstrow"><th>group (given)</th><th>class (given)</th><th>drop down with unique list)</th></tr></thead><tbody>
<tr><td>Inner</td><td>IIIA</td><td>Arteri</td></tr>
<tr><td> </td><td> </td><td>Kolektor</td></tr>
</tbody></table>

<thead>
</thead><tbody>
</tbody>

 

[Ingolf]

Did you look here???

https://www.contextures.com/xlDataVal02.html


Add a Third Dependent Drop Down

 

[muhammad susanto]

thanks but i need some formula...

 

[kvsrinivasamurthy]

Maximum how many rows wil be there.

 

[muhammad susanto]

100 rows

 

[Ingolf]

thanks but i need some formula...

Did you read the article?
There are also formula...

 

[muhammad susanto]

i think in my case is complex..