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!

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

--
Gary's Student


"Ed" wrote:

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!