Excel - Advanced filter with wildcards
I am trying to filter (DATA > Advanced under "Sort & Filter) a range of fields based on a wildcard + text based on the info I'm finding here: https://www.contextures.com/xladvfilter01.html
But when I use the * wildcard, it is returning filtered results such as *string*, instead of *string. For instance, I am using *-1 to try and get any field in this column ending in "-1", but I am receiving results such as 15-110 (with -1 in the middle).
Sample:
I don't want the output highlighted in red to be included in the filtered results. Just the remaining 3 items.
Solution
Try the following as your criteria:
="=*-1"
This would work because we can mix up a wildcard with these logical operators as described as below to check for an exact match:
- Tiling an Excel array in 2 dimensions, ideally not using VBA
- How to inner-join in Excel (eg. using VLOOKUP)
- Scientific notation when importing from Excel in .Net
- More efficient way to loop through lines and duplicate if a certain character is found
- How to get the referenced value of a formula cell in the correct data type with SlapKit.Excel?
- Excel List Parse Table
- Extract number from the end of text string in Excel
- Normal.dotm equivalent in Excel for referencing the same single VBA code
- What Run time error in an SQL Query for join means
- Create A Chart On Each Worksheet Using The Data From That Worksheet
- Equivalent of Excel's Weeknum function in Python
- Any way to set minimum Cell Height in an Excel Sheet?
- Excel Power Query syntax issue transform multiple columns of records
- Userform with Excel 2018 for MacOS
- How to Rank Items by Multiple Criteria in Excel
- Extracting digits from a cell with varying char length
- Find the minimum value of a range based on presence of a substring in another range
- Grouping dates from rows
- How do I stop my for loop from erroring out
- Excel: Extract a sequence of n numbers from a string with a formula
- How to copy multiple sheets to a master sheet using distinct column headers
- DLL load failed while importing aggregations: The specified module could not be found pyhton pandas excel files merging
- With openpyxl, how do I collapse all the existing groups in the resultant excel?
- tcom tcl: Error when trying to add hyperlink with link of length more than 255 characters
- Concat in EXCEL like MySQL
- How to copy the conditional formatting without copying the rules from a Conditional Formatted cell?
- VBA Speeding Up Index-Match for Large Dataset
- Date cleaning in excel,date values align to the left
- Selecting sheets based off of a dynamic range, then exporting
- Importing XML from SharePoint by looping through a set of variables