Hi,

I have a table (in MS Excel) with values like this

LocalCurrency, Amt, BaseCurrency, ValueDt, TestColumn

I want to delete all rows where the column LocalCurrency=BaseCurrency

Of course I can create a loop through all the cells and delete the rows, but
I want a one line option if possible.

I have a column where a test is done that returns TRUE or FALSE if the
currencies match, but how can I use SpecialCells to return all those rows
where it is True and delete them?

I saw something along these lines a couple of months back but now cannot
find it..

thanks for any tips, or showing me the way

Philip