This video clearly explains step by step process of making a searchable dropdown list in MS excel Enjoy!!! Useable information Equations in F3 cell : =--ISNUMBER(IFERROR(SEARCH($B$3,E3),"")) 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)),"") download the excel sheet here https://drive.google.com/file/d/1yg9-lqwA7sW2ZeStERPNKwEzoHacwbPB/view?usp=sharing Don't forget to subscribe and share Thank you
No comments:
Post a Comment