Delete Rows based on value/s in certain cells

preview_player
Показать описание
00:00 Use a helper column to decide which rows to keep/ delete
00:10 Set up a column to test for a key number in the row
01:05 Use the Filter on the helper column

Using a helper column, determine which rows are to be kept or deleted. This is useful where there is a more complex criteria e.g. the rows contains a number in a cell, or if there is a number in one cell, and date in another, keep the row.
Рекомендации по теме