Forum Discussion
Solved
Filtering cells onto a new sheet based on values in a column
I'm not sure how to use VLookup or Index to achieve this. I have a sheet that contains multiple columns of data. From that I want to create a second sheet that returns values from only two columns ba...
To achieve this in Excel, you can utilize the FILTER function if you're using a version of Excel that supports it (like Microsoft 365 or Excel 2019 and later). Here's how you can do it:
On Sheet2:
In cell A1, enter the formula:
=FILTER(Sheet1!C:C, Sheet1!A:A="USA")
In cell B1, enter the formula:
=FILTER(Sheet1!E:E, Sheet1!A:A="USA")
These formulas will populate columns A and B on Sheet2 with the names and numbers from Sheet1 where the country is "USA".
To achieve this in Excel, you can utilize the FILTER function if you're using a version of Excel that supports it (like Microsoft 365 or Excel 2019 and later). Here's how you can do it:
On Sheet2:
In cell A1, enter the formula:
=FILTER(Sheet1!C:C, Sheet1!A:A="USA")
In cell B1, enter the formula:
=FILTER(Sheet1!E:E, Sheet1!A:A="USA")
These formulas will populate columns A and B on Sheet2 with the names and numbers from Sheet1 where the country is "USA".
Thank you! Adding this to my repertoire