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