filmov
tv
Delete Rows based on value/s in certain cells
Показать описание
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.
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.