Excel Multi-Dependent List (Remove Duplicate)

[Darren_Yong]

Hi,

Need help to remove duplicate for "TYPE"

  

Thanks

Darren

[#2]

Hi,

Attached full screen. Thks

[#3 · Accepted solution]

@Darren_Yong 

You may create helper spills as on the right and use them in data validation:

[#4]

@Sergei Baklan 

Thank you, your formula is brilliant.

For the "Code" column, what will be the formula?

Select " Cotton" follow by " Shirt" will show "S, M, L".

Thanks. Darren

[#5]

@Darren_Yong 

You may add one more set like

[#6]

@Sergei Baklan 

 Done. Thank you for your guidance.

[#7]

@Darren_Yong 

Congratulations!!!

Now you can learn about SKU numbering:

Here's a site link with a free download of SKU generator:

How to create SKU numbers (tradegecko.com)

[#8]

@Darren_Yong , glad it helped