Forum Discussion

H1D3F's avatar
H1D3F
Copper Contributor
Sep 25, 2019

Help with formula

Hello, I am trying to remove the blank selections from a dependent drop list I have created in Excel and I am having a hard time figuring out what the formula would be to get this accomplished. A li...
Excel - formulas data worksheet
Twifoo's avatar
Twifoo
Silver Contributor
Oct 05, 2019

H1D3F 

In the attached file, the formula for CountedPortfolios is: 

=INDEX(Portfolios,1,

MATCH(!A2,Managers,0)):INDEX(Portfolios,

PortfolioCount,MATCH(!A2,Managers,0))

Note that all formulas are dynamic.

Resources