Google Sheet Filter Values From One Sheet To Another Sheet

Let's say you have the following data in Sheet1:

You want to filter this data to show only the rows where the Country is "USA".

In FilteredSheet, enter the following formula in cell A1:

FILTER(Sheet1!A:C, Sheet1!C:C = "USA")

This will filter and display only the rows where the Country is "USA" in the FilteredSheet.

Explanation:

• FILTER(range, condition): The FILTER function takes two arguments: the range of data to filter and the condition to apply.
• Sheet1!A:C: This specifies the range of data in Sheet1 from columns A to C.
• Sheet1!C:C = "USA": This specifies the condition to filter the data where the values in column C are "USA".