SOLVED

Excel Multi-Dependent List (Remove Duplicate)

%3CLINGO-SUB%20id%3D%22lingo-sub-2724187%22%20slang%3D%22en-US%22%3EExcel%20Multi-Dependent%20List%20(Remove%20Duplicate)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2724187%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENeed%20help%20to%20remove%20duplicate%20for%20%22TYPE%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Darren_Yong_1-1630922217675.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F308294i726AE5D95F79C4D6%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Darren_Yong_1-1630922217675.png%22%20alt%3D%22Darren_Yong_1-1630922217675.png%22%20%2F%3E%3C%2FSPAN%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Darren_Yong_2-1630922266080.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F308295iC9EE6B79FD800D76%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Darren_Yong_2-1630922266080.png%22%20alt%3D%22Darren_Yong_2-1630922266080.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Darren_Yong_3-1630922554112.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F308296i524459AF14823721%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Darren_Yong_3-1630922554112.png%22%20alt%3D%22Darren_Yong_3-1630922554112.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EDarren%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2724187%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2724219%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Multi-Dependent%20List%20(Remove%20Duplicate)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2724219%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAttached%20full%20screen.%20Thks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Darren_Yong_1-1630922940362.png%22%20style%3D%22width%3A%20712px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F308298i9713E2ED3AA75D24%2Fimage-dimensions%2F712x244%3Fv%3Dv2%22%20width%3D%22712%22%20height%3D%22244%22%20role%3D%22button%22%20title%3D%22Darren_Yong_1-1630922940362.png%22%20alt%3D%22Darren_Yong_1-1630922940362.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2726253%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Multi-Dependent%20List%20(Remove%20Duplicate)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2726253%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1141926%22%20target%3D%22_blank%22%3E%40Darren_Yong%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20create%20helper%20spills%20as%20on%20the%20right%20and%20use%20them%20in%20data%20validation%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20762px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F308385i06FD374DDA811832%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2727104%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Multi-Dependent%20List%20(Remove%20Duplicate)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2727104%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%2C%20your%20formula%20is%20brilliant.%3C%2FP%3E%3CP%3EFor%20the%20%22Code%22%20column%2C%20what%20will%20be%20the%20formula%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESelect%20%22%20Cotton%22%20follow%20by%20%22%20Shirt%22%20will%20show%20%22S%2C%20M%2C%20L%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%20Darren%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Darren_Yong_0-1630991980996.png%22%20style%3D%22width%3A%20729px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F308435i6C2BA3CEBE60FF50%2Fimage-dimensions%2F729x277%3Fv%3Dv2%22%20width%3D%22729%22%20height%3D%22277%22%20role%3D%22button%22%20title%3D%22Darren_Yong_0-1630991980996.png%22%20alt%3D%22Darren_Yong_0-1630991980996.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2728656%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Multi-Dependent%20List%20(Remove%20Duplicate)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2728656%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1141926%22%20target%3D%22_blank%22%3E%40Darren_Yong%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20add%20one%20more%20set%20like%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20826px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F308541iEB8F63AB61AA827B%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2731390%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Multi-Dependent%20List%20(Remove%20Duplicate)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2731390%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Darren_Yong_1-1631081751473.png%22%20style%3D%22width%3A%2028px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F308811iCAAE48D266899862%2Fimage-dimensions%2F28x33%3Fv%3Dv2%22%20width%3D%2228%22%20height%3D%2233%22%20role%3D%22button%22%20title%3D%22Darren_Yong_1-1631081751473.png%22%20alt%3D%22Darren_Yong_1-1631081751473.png%22%20%2F%3E%3C%2FSPAN%3E%26nbsp%3BDone.%20Thank%20you%20for%20your%20guidance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Darren_Yong_2-1631081834745.png%22%20style%3D%22width%3A%20732px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F308812i275901E9F650E8C2%2Fimage-dimensions%2F732x220%3Fv%3Dv2%22%20width%3D%22732%22%20height%3D%22220%22%20role%3D%22button%22%20title%3D%22Darren_Yong_2-1631081834745.png%22%20alt%3D%22Darren_Yong_2-1631081834745.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi,

 

Need help to remove duplicate for "TYPE"

 

Darren_Yong_1-1630922217675.png  

Darren_Yong_2-1630922266080.pngDarren_Yong_3-1630922554112.png

Thanks

Darren

7 Replies

Hi,

 

Attached full screen. Thks

 

Darren_Yong_1-1630922940362.png

 

best response confirmed by allyreckerman (Microsoft)
Solution

@Darren_Yong 

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

image.png

@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

Darren_Yong_0-1630991980996.png

 

 

@Darren_Yong 

You may add one more set like

image.png

@Sergei Baklan 

Darren_Yong_1-1631081751473.png Done. Thank you for your guidance.

 

Darren_Yong_2-1631081834745.png

 

 

 

 

 

@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)

 

Yea_So_0-1631082023245.pngYea_So_1-1631082071392.png

 

 

@Darren_Yong , glad it helped