CLEARED is by manual input.Pasadu
How do "CLEARED" appears in cell R13 - by manual input or by formula or how?
Which row should be deleted? ... Can You give clear example of row's number?
I'm sorry for the mix up. Any cell where there is CLEARED, that entire row should be deleted..Pasadu
Your original wish was based cell R13...
With #3 reply, You're writing about column A -- those are different!
YesPasadu
Do You mean now that,
if CLEARED is in cell AA11, F37, D99 then those row 11, 37 and 99 should be deleted?