Forum Discussion

pswanie's avatar
pswanie
Copper Contributor
Feb 22, 2019

populate and or summarize data

not sure what i realy need.. sheet1 have column a row5 =team 1 row10=team 2 row15=team 3 etc column b row5 =personA row6 =personB row7=personC row8 =personD column c row5 =infoforA row6 =infofo...
excel
Formulas and Functions
Twifoo's avatar
Twifoo
Silver Contributor
Feb 22, 2019

Hello pswanie ,

In the attached file, I added Data sheet to rearrange your data according to the proper layout of a dynamic dependent drop-down list. Being dynamic, you can add (or delete) data from the Data sheet without affecting the formulas.