How to delete rows with a formula or script?

G

Gevorg2021-09-27 16:28:03

Google Sheets

Gevorg, 2021-09-27 16:28:03

You need to delete a row if there is no data in a certain column. There are several mini-tables in the sheet, so the entire row does not need to be deleted.
For example: if there are no values in cell B5, then cells A5, B5, C5 are deleted.

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

Alexander, 2021-09-27
@Alexandre888

https://exceljet.net/excel-functions/excel-if-function

Similar questions

M

mUchenik2020-08-20 14:32:10

How to register a function with changes in cells in Google sheets? 1Reply

M

Maksim19882020-08-21 08:50:59

Is there a free analogue of Google Spreadsheets with access control? 3Reply

L

lenka-elenkaa2021-12-08 16:19:39

How to write formula in pivot table filter by date? 0Reply

A

Alexey Mikhailov2020-08-25 17:07:34

How to count number of numbers in strings using array formula? 2Reply

C

c14nyk2021-12-16 17:54:48

How to auto-update the formula in Google Sheets if the data in the cell is taken from the site by reference? 2Reply

Didn't find what you were looking for?

Ask your question