Data Validation With Unique Drop Down List

[muhammad susanto]

hi all..

i have the data this below :


[TABLE="class: tableizer-table"]
<thead>[TR="class: tableizer-firstrow"]
[TH]Group[/TH]
[TH]Class[/TH]
[TH]Type[/TH]
[/TR]
</thead><tbody> [TR]
[TD]Inner[/TD]
[TD]I[/TD]
[TD]Arteri[/TD]
[/TR]
[TR]
[TD]Inner[/TD]
[TD]II[/TD]
[TD]Arteri[/TD]
[/TR]
[TR]
[TD]Inner[/TD]
[TD]IIIA[/TD]
[TD]Arteri[/TD]
[/TR]
[TR]
[TD]Inner[/TD]
[TD]IIIA[/TD]
[TD]Kolektor[/TD]
[/TR]
[TR]
[TD]Inner[/TD]
[TD]IIIB[/TD]
[TD]Kolektor[/TD]
[/TR]
[TR]
[TD]Inner[/TD]
[TD]IIIC[/TD]
[TD]Jalan Lokal[/TD]
[/TR]
[TR]
[TD]Outer[/TD]
[TD]I[/TD]
[TD]Arteri Primer[/TD]
[/TR]
[TR]
[TD]Outer[/TD]
[TD]I[/TD]
[TD]Kolektor Primer[/TD]
[/TR]
[TR]
[TD]Outer[/TD]
[TD]I[/TD]
[TD]Arteri Sekunder[/TD]
[/TR]
[TR]
[TD]Outer[/TD]
[TD]II[/TD]
[TD]Kolektor Primer[/TD]
[/TR]
[TR]
[TD]Outer[/TD]
[TD]II[/TD]
[TD]Arteri Sekunder[/TD]
[/TR]
[TR]
[TD]Outer[/TD]
[TD]II[/TD]
[TD]Kolektor Sekunder[/TD]
[/TR]
[TR]
[TD]Outer[/TD]
[TD]IIIA[/TD]
[TD]Kolektor Sekunder[/TD]
[/TR]
[TR]
[TD]Outer[/TD]
[TD]IIIA[/TD]
[TD]Jalan Lokal[/TD]
[/TR]
[TR]
[TD]Outer[/TD]
[TD]IIIB1[/TD]
[TD]Jalan Lokal/Parkir[/TD]
[/TR]
[TR]
[TD]Outer[/TD]
[TD]IIIB2[/TD]
[TD]Jalan Lokal/Parkir[/TD]
[/TR]
[TR]
[TD]Outer[/TD]
[TD]IIIC[/TD]
[TD]Jalan Lokal/Parkir[/TD]
[/TR]
</tbody>[/TABLE]

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>

[TABLE="class: tableizer-table"]
<thead>[TR="class: tableizer-firstrow"]
[TH][/TH]
[TH][/TH]
[TH][/TH]
[/TR]
</thead><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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..