ExcelBanter - If a Row is blank

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - If a Row is blank (https://www.excelbanter.com/excel-worksheet-functions/111462-if-row-blank.html)

jac007

If a Row is blank

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 a Row is blank

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

jac007

If a Row is blank

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?

Carim

If a Row is blank

Hi,

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

should do the job ...

HTH
Cheers
Carim

shail

If a Row is blank

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 wrote:
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?

jac007

If a Row is blank

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

"Carim" wrote:

Hi,

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

should do the job ...

HTH
Cheers
Carim

jac007

If a Row is blank

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" wrote:

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 wrote:
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?

shail

If a Row is blank

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?

Bernie Deitrick

If a Row is blank

jac,

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

HTH,
Bernie
MS Excel MVP

"jac007" wrote in message
...
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?

Leo Heuser

If a Row is blank

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

"Carim" wrote:

Hi,

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

should do the job ...

HTH
Cheers
Carim

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.

--
Best regards
Leo Heuser

Followup to newsgroup only please.

Bernie Deitrick

If a Row is blank

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

"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
jac,

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

HTH,
Bernie
MS Excel MVP

"jac007" wrote in message
...
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?

Leo Heuser

If a Row is blank

"Bernie Deitrick" <deitbe @ consumer dot org skrev i en meddelelse
...
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")

--
Best regards
Leo Heuser

Stefi

If a Row is blank

Thanks Leo,

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

€žLeo Heuser€ ezt Ã*rta:

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

"Carim" wrote:

Hi,

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

should do the job ...

HTH
Cheers
Carim

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.

--
Best regards
Leo Heuser

Followup to newsgroup only please.

Leo Heuser

If a Row is blank

"Stefi" skrev i en meddelelse
...
Thanks Leo,

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

You're welcome, Stefi.

Regards
Leo Heuser

All times are GMT +1. The time now is 03:07 AM.