How to make multiple searchable Dropdown list | Filter list in excel | in excel | Malayalam | No VBA

 

This video is an extension/updating of the previous video of searchable dropdown list Topics include * How to create a multiple searchable dropdown list * how to remove null spaces in dropdown list * how to assign a name range watch this first part video before for better understanding -- https://youtu.be/-tYvT860TXY Useable information Download the sample excel file here https://drive.google.com/file/d/1YGqt-wm-PVzzlZMsOnUBqI-d7KutrUuK/view?usp=sharing Equations in F3 cell : ==--ISNUMBER(IFERROR(SEARCH(INDIRECT(CELL("address")),E4),"")) IN G3 cell : =IF(F3=1,COUNTIF($F$3:F3,1),"") in H3 cell : =IFERROR(INDEX($E$3:$E$26,MATCH(ROWS($G$3:G3),$G$3:$G$26,0)),"") in Name manager refer to cell : =OFFSET(Sheet1!$H$3,,,COUNTIF(Sheet1!$H:$H,"*?"))