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 =infoforB row7 =infoforC row8 =infoforD


sheet 2 the user need to select a dropdown or row etc for team 1 and get info for rows 5,6,7,8 only. select team 2 and get info for row 9,10,11,12 etc

see attached non working example

excel
Formulas and Functions

1 Reply

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Feb 23, 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. 

Resources