Prompt Title: Google Sheets: Filter and Move.

Created 7 months ago
Votes 0
Views 132 times

Prompt Detail:

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


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.

richard bunce
Shared 1 prompt
Created 7 months ago

Leave a Comment

Related Tag Prompts

Google Sheets Guru
10 months ago 2023-01-29 07:55:22 AIPRM
get Current Workbook Name and sheet
8 months ago 2023-03-15 08:24:27 lamin99
Google Sheets SMS Script
8 months ago 2023-04-03 16:53:35 ben
Find and Delete Cell Content
7 months ago 2023-05-03 18:27:10 Ray Celeste
Adjusting Survey Prompt
3 months ago 2023-08-31 19:34:50 Tom