Forum Discussion
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 LUGS, RIG 143 |
| 18600-Savanna, REPAIR JACO CATWALK SKATE ASSEMBLY, 653 |
| 18601-Savanna, REPAIR BAIL TILT CYLINDER, 653 |
| 18602-NS Modular, 8" LTC, 6PCS |
And I only want to see "Ensign" jobs.
Thank you
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.
2 Replies
If you want to use a formula you can try:
= filter(a1:a5;isnumber(search("Ensign";a1:a5)))
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.
