Hi,
want to create auto sugest & auto pop up data validation list same as google sheet, without Macro & VB in Office 365.
Please check attached image below. i want ot do same in Excel, if i type any word in that Location Column then it should automatically pop up,
for Ex, if i Type Mech then all the Mech Options should autosuggest & autopop up in Excel. this thing is easily available in google Sheets but want to creat in Excel without using Macro or VB.
Thanks.