How to sort only one type of data from a column

Hi,
I am working on a large database, and for that database we need to sort some of the information out and transfer to another sheet. I want to look at only specific data to perform some analysis. For instance, in a spreadsheet that has both male and female workers, how do I create a separate list of only female workers in a new sheet for the same workbook? The only thing that I could think of is VLOOKUP but I am not sure if that will work. Any help would be appreciated! Thanks in advance for your time!

Please post a sample file (not image) demonstrating what you require.

To upload a file, click "Go Advanced" then scroll down to "Manage attachments"

Hi @Ranh
You want create a new table filtered or filtered and sorted? Why not use filter, sort, copy, paste?
Assuming you want dynamically filter to a new table in a new sheet, and assuming your first table is Table_A with (Name, Gender, Age) in Sheet1
You can use the following formula in Sheet2 Table_B with(Row_Id, Name, Gender, Age) to get the rows you want transfer ($G$2 has the Filter for Gender).

Formula:

Please Login or Register  to view this content.

Now, you can use INDEX to fill the rest of Table_B as (to get column Name

Formula:

Please Login or Register  to view this content.

See the sample file