PDA

View Full Version : Help with deleteing row conataining #VALUE!



selkov
09-10-2007, 09:55 AM
I want to sort thru the list and delete any row that conatins "#VALUE!" in colum B.

What sytanx do I use do isolate that data ?

Bob Phillips
09-10-2007, 10:41 AM
Sort the column B.

Filter the column B, Data>Filter>Autofilter

Select the value of #'VALUE!

Then delete the visible rows.