SOLVED: How To Filter or Select or Remove Rows in An Excel Table Based on A Cells Contents

If you have an Excel table with a number of ROWS you want to have selected and removed based on the contents of a cell, you can use the SORT & FILTER editor.  It is very easy to use.

1. Simply click on the column you want to evaluate
2. On the HOME tab click  SORT & FILTER then click the FILTER from the drop down
3. Click drop down box at the top of the column you selected in step 1
4. Click TEXT FILTERS
5. Click BEGINS WITH or any other rule that is appropriate for you
6. Add any other rules you want to the CUSTOM AUTOFILTER box
7. Have a nice day

To make this easier to understand we have a 90 second video showing the steps: