Very Specific Filtering

[bradjedis]

Greetings,

I have a great deal of data in col A. I am needing to Filter to only show the items that end in "-xxxxx" where the xxxxx is exactly 5 characters.

the xxxxx could be any character.

Thoughts?

[HansV]

You can use Advanced Filter for this.
Let's say the data begin in A2.

In an empty column, set up a two-cell criteria range.
Leave the top cell empty.
Enter the formula =MID(A2,LEN(A2)-5,1)="-" in the bottom cell of the two.
It may return #VALUE! but that doesn't matter.

S2421.png

Click in any cell of the data range.
On the Data tab of the ribbon, click Advanced.
Excel will automatically select the data range in the 'List range' box.
Click in the 'Criteria range' box and select the two cells of the criteria range mentioned above.

S2422.png

Click OK to see the result.

S2423.png

[robertocm]

A workbook with an advanced filter macro
for testing

notebook.xlsm

[snb]

Code: Select all

Sub M_snb()
   Columns(1).AutoFilter 1, "*-?????"
End Sub

[bradjedis]

Have bit tried the Sub, but I will. Will test the above attachment soon

[rory]

Manually you can do it with autofilter by selecting Text filters - ends with, and entering the -?????