Forum Discussion
Populate dynamic list of row or column items based on table value.
Hi everyone, I am trying to generate two lists based on a "y" or "n" value in the table. The image above shows my desired result in red box. any help would be great.
Maybe this...
In H4
=SORT(FILTER(B5:B8,INDEX(C5:E8,,MATCH(H$3,$C$4:$E$4,0))="y"))
In J4
=SORT(TRANSPOSE(FILTER(C4:E4,INDEX(C5:E8,MATCH(J$3,$B$5:$B$8,0),)="y")))
Subodh_Tiwari_sktneer Thank you so much for sharing the formula.
However, for me it isn't working if C4, D4, E4 contains date value.
How do I convert date or do I have to try different formula at H4 and J4?
Thanks.