Aug 25 2020 03:14 AM
Hallo, ich möchte einen Katalog in Excel machen mit dem Excel Dropdown. Allerdings würde ich gerne, anstatt immer manuell aussuchen zu müssen welches Wort man nimmt, gerne die Auswahlmöglichkeiten automatisch gefiltert haben. So dass ich beispielsweise, wenn ich die ersten zwei Buchstaben eines Wortes eingebe, alle Wörter angezeigt bekomme die mit den Buchstaben anfangen. Geht das ?
Danke für eure Hilfe!
LG
Aug 25 2020 03:54 AM
That is not possible with the data validation dropdown, but it can be done using a combo box.
Aug 25 2020 05:28 AM - edited Aug 25 2020 05:36 AM
@JuliusDaredevil Yes there are a number of tutorials on how to create this functionality. Basically you use a helper column so the data validation is based on this helper column, which is a filtered list based on what you type in that cell.
So if column A has the list and cell C1 has the dropdown, then in cell B1 enter something like:
=SORT(FILTER(A:A,LEFT(A:A,LEN(C1))=C1))
then C1 data validation list would be based on column B so after you type your first letter or 2 then hit the dropdown you only see the entries in the list that match.
NOTE: I have seen some reports that Mac Excel doesn't update when you hit the dropdown arrow so they have to hit enter THEN dropdown button.
Here is a link with a tutorial. This tutorial narrows the list based on a more general search (the typed info can appear anywhere in the list item instead of only starting as you requested) but the technique is well explained:
https://www.xelplus.com/searchable-drop-down-list/