If a Row is blank

[jac007]

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?

 

[Stefi]

=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:

 

[jac007]

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.

 

[Carim]

Hi,

=IF(AND(ISBLANK(A2),ISBLANK(B2),ISBLANK(C2),ISBLANK(D2),ISBLANK(E2),ISBLANK(F2),ISBLANK(G2),ISBLANK(H2),ISBLANK(I2),ISBLANK(J2))=TRUE,"Remove","Keep")

should do the job ...

HTH
Cheers
Carim

 

[shail]

Hi,

Use the formula as :

=IF(A2:J2="","Remove","Keep")

Don't forget to use the CRTL+SHIFT+ENTER keys to execute the function,
instead of simply pressing the ENTER key. Braces will appear over both
the ends if you press the keys correctly in the formula bar and your
desired output at the cell.

Hope that helps you.

Thanks,
Shail

 

[jac007]

That helped, thanks! However, that is a long formula I wish the one stefi
posted would have worked since it was short. Thanks!

 

[jac007]

Did what you said and it does the same as stefi's. I did put ctrl + shift +
enter and gave me this {=IF(A2:J2="","Remove","Keep")} and I dragged that
formula all the way down and I checked to see if the other cells continued to
put the {} and it did I got on K3 {=IF(B3:J3="","Remove","Keep")} appeared
and so on.

 

[shail]

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


Shail

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.

 

[Bernie Deitrick]

jac,

=IF(COUNTA(A2:J2)=0, "Remove","Keep")

HTH,
Bernie
MS Excel MVP

 

[Leo Heuser]

That helped, thanks! However, that is a long formula I wish the one stefi
posted would have worked since it was short. Thanks!

stefi's formula needs the AND to work.

=IF(AND(ISBLANK(A2:J2)),"remove","keep")


Still <Shift><Ctrl><Enter>


AND(ISBLANK(A2:J2))

is the shorter form of Carim's formula, but for it to work,
it has to be array-entered.

 

[Bernie Deitrick]

I should have mentioned that if you have formulas that return "", then you should use

=IF(COUNTBLANK(A2:J2)=10, "Remove","Keep")

HTH,
Bernie
MS Excel MVP

 

[Leo Heuser]

I should have mentioned that if you have formulas that return "", then you
should use

=IF(COUNTBLANK(A2:J2)=10, "Remove","Keep")

HTH,
Bernie
MS Excel MVP

Or

=IF(COUNTBLANK(A2:J2)=COLUMNS(A2:J2), "Remove","Keep")

 

[Stefi]

Thanks Leo,

I didn't understand what's wrong with my formula!
Regards,
Stefi


„Leo Heuser†ezt írta:

 

[Leo Heuser]

Thanks Leo,

I didn't understand what's wrong with my formula!
Regards,
Stefi

You're welcome, Stefi.

Regards
Leo Heuser