Match Forumla With Delete!

[longytravel]

Guys,

I have a match formula that returns a True / False result (Column J)

My data is in a table that runs from G : K - there are other tables to the left and right of this one

I would like a way of removing all the entries that return a 'True'

due to tabkleas being either side i cant delete the whole row just the row detail in columns G : K

There are 1400 entries and the Trues are spread at random

Any thoughts?

Cheers

 

[AlphaFrog]

• Select column J
• Select from the menu Data\ Filter\ Autofilter
• This will put a dropdown list in cell J1
• Select from the J1 drop down list: TRUE
• This will show only the column J TRUE rows
• Select the visible data in columns G:K and delete or clear.
• Select Autofilter from the menu again to turn it off