Set up an auto filter.
Select the whole Column where the Y appears, then from the main menu
Click on Data - Filter - Auto Filter
You will see a drop dow box appear in your column; click on it and find the
Y,this should select all of the rows that contain a Y. Then click on the rows
and hit delete, it will delete only the visible rows. The follow the same
procedure to remove the filter as you did to set it up.
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"amboo_radley" wrote:

I have a data set that looks like this:

LA BEL: M_FRONT _HEIGHT
Po ints Taken: 1
Actual Nominal #NAME? #NAME? Dev Out/Tol
Y: 1808.608 1808.8 1.5 -1.5 -0.192 **********


LA BEL: M_REAR_ HEIGHT
Po ints Taken: 1
Actual Nominal #NAME? #NAME? Dev Out/Tol
Y: 1808.3624 1808.8 1.5 -1.5 -0.4376 **********


I want to delete all the rows except those that have Y: in the first column.
How would I do that? Everything I have tried so far has only deleted some
of the rows, but not all.