Forum Discussion
Solved
Help needed to filter in Excel please
How do I filter our spreadsheet to populate a list with only lines containing the search word? For example: 18598-Ensign, 6 - 3 POSITION TIE LUGS, RIG 141 18599-Ensign, 6 - 3 POSITION TIE LU...
Here’s the easiest way to filter your spreadsheet to show only rows that contain "Ensign" (or any other word you choose).
Use AutoFilter
If your data is in one column:
- Select your data (or click any cell in the list).
- Go to Data → Filter.
- Click the filter drop-down arrow on your column.
- Choose Text Filters → Contains...
- Type Ensign.
- Click OK.
You'll only see rows containing "Ensign".
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.
If you want to use a formula you can try:
= filter(a1:a5;isnumber(search("Ensign";a1:a5)))