Filtering out multiple "begins with..." (for letters) -- help!

Here is a VBA solution that may work for you. Assumes data is in column A beginning in the second row. Hides all rows that have cells in Column A beginning with A,D or J

Please Login or Register  to view this content.

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button

Maybe add a new column with this formula:

=OR(LEFT(A2)={"A","J","D"})

Copy down as needed.

Then you could filter on this column =TRUE.

Perhaps a sample portion of your spreadsheet so that we can test both solutions and determine why they are not working for you. Upload by clicking on the Go Advanced button at the bottom of the Reply window. Follow the instructions for uploading a worksheet.

Originally Posted by anderschender

I kept getting an error message that said I was not allowed to change part of an array.

Can't understand why you'd get that message.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks. It is customary to give feedback to those that have helped you by clicking on the asterisk (Add Reputation) at the bottom of their post.