• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Clearing a row based on a value of another cell

Hi everbody,
Is there any way (except VBA) that if one particular cell of a row in a table is cleared (or has no value in it) all of the other row cell's values be cleared?

Thanks
 
Only way i can think of without using VBA is to wrap each cell you want cleared simultaneously in an if statement i.e. if(A2="","","Usual Value") or if(isblank(A2),"","Usual Value"). Although, this wouldn't be practical if the cells you want cleared are manually entered values, in that case you could fudge it by using conditional formatting on the cells to change the font colour to the same as the cell colour if the first cell is empty
 
Only via a formula. Perhaps like:
=IF($B2="","",C2)

If you have hard-written data in the row and you want it cleared, the only way to do that "automatically" is with VBA.
 
Hi,
Thanks for your attention.
I couldn't use this formulas. It is better I upload an example. I want when one of Column1 cells for Example "Helen" is cleared all of that row data be cleared, too
 

Attachments

  • RowClear.xlsx
    8.9 KB · Views: 2
With your current setup, the answer is "no", it can't be done w/o VBA.
If the table you have currently is just used as raw data, we could build an output table somewhere where the user types in a name(s) and then formulas either give the values or blank, but that is the only way to mimic what you want.
 
Back
Top