Forum Discussion

Boulakgnobot's avatar
Boulakgnobot
Brass Contributor
Oct 17, 2023

HELP_DEPENDENT DROP-DOWN LISTS

Hi everyone !   Here is my dependent drop-down lists PROBLEM: - I have 4 LEVELS (3e, 4e, 5e, 6e) in DATA VALIDATION - Each LEVEL has 6 CLASSES (A, B, C, D, E, F) example: 3eA, 3eB, 3eC, 3eD, 3eE,...
Formulas and Functions
Boulakgnobot's avatar
Boulakgnobot
Brass Contributor

Thanks ! I mistake with orientation ! Instead of "above" file it was "BELOW" NEW FILE with the PICTURE illustration

 

I'm SORRY !

 

YES I'm Excel 365

 

https://www.cjoint.com/c/MJtwF6cLaXs

 

PS: If you CAN HELP again

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Oct 20, 2023

Boulakgnobot Sorry, don't understand. Looks like a very similar file (if not the same) as the previous one.

  • Boulakgnobot's avatar
    Boulakgnobot
    Brass Contributor
    Oct 20, 2023

    What remains is the cumulative table of lists maybe with "FILTER" or "VSTACK" FUNCTIONS and PULL OUT empty spacies (zeros) and "SORT" (FUNCTION) by {last name;name}

     

    https://www.cjoint.com/c/MJtwF6cLaXs

     

Resources