samedi 31 octobre 2020

Google Sheet - Delete rows if cells contain NO VALUES

I have an array A15:G63, what I would like to do is create a button called 'Clear'

The purpose of the button is:

  • Between A15:G63, if a cell has no values (usually the value input is a string) I would like to delete that row. It could be multiple rows.

For example: I enter the word 'HI' in A15:G55, nothing in A56:G59, and the word 'HELLO' in A60:G63. I would like to delete rows 56-59.

How do I do that?

Thanks all.

Aucun commentaire:

Enregistrer un commentaire