I used the following website to my advantage the only downsite is that the dropdown doesn't show unique options. so if data shows op 3 times it also show 3 times in the dropdown menu
is there a way to adjust that??
source: https://www.extendoffice.com/documents/excel/2439-excel-drop-down-list-search.html