Filter
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!
|