Hi All,
I have a school project where I have to create a dynamic list to populate the toys where in the columns it states "yes". I have been practicing for ages by searching the forum and tried my best to learn from other sources and I seem to confuse myself. Below formula is what I compiled but its not working.
The yellow is my formula "{=SMALL(INDEX(ISNUMBER($B$4:$I$4)*COLUMN($B$4:$I$4),0),COUNTBLANK($B$4:$I$4)+COLUMN(B3))}"
The red cells show what result I need
I have attached sample to give an idea.
Can someone please help me with this formula?
Thank you so much in advance!
Bookmarks