|
Posted to microsoft.public.excel.misc
|
|
|
Excel If statememnts
"Chip Pearson" wrote:
A formula cannot delete rows.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"mjlucas49" wrote in
message
...
I have the following function in an Excel spreadsheet. How can
I change it
to delete a row instead of just printing No? I am thinking of
how I use the
ALt key and arrows to get to the Edit menu and delte row
option.
=IF(A4<A5,"No",IF(AND(B4=B5),"Yes","No"))
Thanks in advance.
Michael Lucas
Could I copy the resultss that my functions provide so they are the values, then sort by the values, and the delete the row I don't need?
Michael
|