possible? =if(That cell = "a certain word", delete row, go next)
 

Can Conditions include operative actions if true or false? such as:

If cell A7 = "Smith", delete row if yes, go to next cell if no ???

possible? =if(That cell = "a certain word", delete row, go next)
 

Jim

No, functions can only return a value, you will need a macro if you want
automated actions

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Jim" wrote in message
...
Can Conditions include operative actions if true or false? such as:

If cell A7 = "Smith", delete row if yes, go to next cell if no ???

possible? =if(That cell = "a certain word", delete row, go next)
 

Jim,
You need to use VBA to do this.

Deletes any row containing Smith in column A .... must start at last row and
work upwards

Sub DeleteRow()
e.g For r = 100 to 1 step -1
If cells(r,1)=Ucase("Smith") then
cell(r,1).entirerow.delete
End if
Next r
End sub

"Jim" wrote:

Can Conditions include operative actions if true or false? such as:

If cell A7 = "Smith", delete row if yes, go to next cell if no ???