That's what you wanted I guess........


Shail


jac007 wrote:
Thanks for the prompt response, but that didn't work completly because there
were some rows that had values and it said "remove" and viceversa.

"Stefi" wrote:


=IF(ISBLANK(A2:J2),"remove","keep")
This is an array formula, confirm with Ctrl+Shift+Enter, then drag it down
as necessary!

Regards,
Stefi



,,jac007" ezt írta:

I would like a formula that will indicate if a row is blank or not.

this function in cell K2 {if A2:J2 is null, then put "Remove", else "Keep".}
so if that range is blank then put "Remove" if C2 has a value then put
"Keep" in K2 cell

How would I do this?