Prompt Title: Google Sheets: Filter and Move.

Created 1 year ago
Votes 0
Views 253 times
0

Prompt Detail:

To move rows with certain values in a column to a different sheet in Google Sheets, you can use the following formula:

css
=FILTER(Sheet1!A:C,Sheet1!B:B="value_to_be_filtered")

This formula will filter the rows in columns A to C in Sheet1 based on the condition that the value in column B matches the specified value, and return the filtered rows in the same columns in a new sheet.

To use this formula, follow these steps:

  1. Create a new sheet where you want the filtered rows to be moved to.
  2. In the first row of the new sheet, enter the column headers that match the headers in Sheet1.
  3. In the first cell of the new sheet below the headers, enter the above formula, replacing "value_to_be_filtered" with the value you want to filter by.
  4. Press enter to apply the formula, and the filtered rows will be displayed in the new sheet.

Note that this formula only displays the filtered rows in the new sheet, but does not actually move them from Sheet1. To remove the filtered rows from Sheet1, you can either manually delete them or use a separate formula to copy and paste them to the new sheet.

avatar
richard bunce
Shared 1 prompt
Created 1 year ago

Leave a Comment

Related Tag Prompts

84
0
0
0
0
0
Google Sheets SMS Script
1 year ago 2023-04-03 16:53:35 ben
0
0
Find and Delete Cell Content
1 year ago 2023-05-03 18:27:10 Ray Celeste
0
0
Adjusting Survey Prompt
9 months ago 2023-08-31 19:34:50 Tom