Data Validation

%3CLINGO-SUB%20id%3D%22lingo-sub-1570776%22%20slang%3D%22en-US%22%3EData%20Validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1570776%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20spreadsheet%20with%20a%20list%20of%20alphabetized%20names.%20%26nbsp%3BI%20want%20to%20create%20a%20Data%20Validation%20cell%20that%20will%20point%20to%20the%20list%20and%20provide%20a%20drop%20down%20for%20selection.%20%26nbsp%3BThe%20part%20that%20I%20have%20not%20been%20able%20to%20do%20is%20show%20only%20the%20names%20starting%20with%20a%20certain%20letter%20if%20I%20type%20it%20into%20the%20cell.%20%26nbsp%3BWhat%20is%20the%20secret%20to%20showing%20only%20the%20name%20starting%20with%20typed%20in%20letters%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1570776%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1570844%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1570844%22%20slang%3D%22en-US%22%3EThe%20secret%20is%20to%20use%20Excel%20on-line%20which%20does%20have%20this%20feature.%20Mac%20and%20Windows%20Excel%20require%20VBA%20programming%20to%20get%20this%20to%20work%20I'm%20afraid.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1570872%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1570872%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F750198%22%20target%3D%22_blank%22%3E%40dadpope40%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Edoes%20this%20is%20what%20you%20are%20looking%20for%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1570976%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1570976%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F750198%22%20target%3D%22_blank%22%3E%40dadpope40%3C%2FA%3E%26nbsp%3B%20I%20tweaked%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F746148%22%20target%3D%22_blank%22%3E%40ramizassaf%3C%2FA%3E%26nbsp%3B%20sheet%20to%20filter%20for%20only%20the%20names%20starting%20with%20that%20letter%20or%20letter%20sequence%20because%20that%20is%20what%20you%20asked%20for.%26nbsp%3B%20That%20said%20his%20original%20is%20nice%20to%20use%20because%20you%20can%20start%20typing%20first%20or%20last%20name...%26nbsp%3B%20but%20it%20is%20up%20to%20you%20...%3C%2FP%3E%3CP%3EI%20also%20added%20a%20%22No%20Names%20Found%22%20if%20no%20names%20are%20found.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I have a spreadsheet with a list of alphabetized names.  I want to create a Data Validation cell that will point to the list and provide a drop down for selection.  The part that I have not been able to do is show only the names starting with a certain letter if I type it into the cell.  What is the secret to showing only the name starting with typed in letters?

3 Replies
Highlighted
The secret is to use Excel on-line which does have this feature. Mac and Windows Excel require VBA programming to get this to work I'm afraid.
Highlighted

@dadpope40 

does this is what you are looking for?

@dadpope40  I tweaked @Ramiz_Assaf  sheet to filter for only the names starting with that letter or letter sequence because that is what you asked for.  That said his original is nice to use because you can start typing first or last name...  but it is up to you ...

I also added a "No Names Found" if no names are found.