Filter

E

Ed

Hello how do I manage to make a filter that instead of selecting from a
Dropdown menu I have the options in cells, for example:

"A B C D E F G H I J K L M ...." and what I need to do is to click on a
letter to filter a list

thanks!
 
G

Gary''s Student

SAy your data is in column B starting at B2. In A2 put:
=LEFT(B2,1) and copy down

Column A will contain the first letter of the data in column B. Now switch
on the auto-filter and you can select any letter in column A
 
Top