Forum Discussion
Solved
Need help creating a dynamic list on excel 2016
Hi, I am currently using Excel 2016 and I need help to get a dynamic list based on an input. for instance, I have a dataset with 4 columns out of which I need to give an input (which is a val...
=IFERROR(INDEX($C$2:$C$11,SMALL(IF($B$2:$B$11=$F$5,ROW($A$2:$A$11)-1),ROW(E1))),"")Maybe with this formula. Enter the formula with ctrl+shift+enter as you don't work with Office365 or 2021.
Tik tok account settings can help me