Tip:
Highlight text to annotate it
X
In Excel you can use an advanced filter if you want to take data out of a list and
put it into a different place your workbook
In this example we have a list of orders and we'd like to pull the top orders out of
the list so our criteria here has the same heading --
Total -- as we have
in the main table
and we put in the criteria of greater than fifteen hundred so only the orders that are
greater than that amount
will be pulled out of this table
We would like the data to end up on a different worksheet
so here's our order sheet and we would like to pull the information onto the Top Orders sheet
We only want the date and customer from that table so those are the only headings i've
put here
which is where we'll extract the data
if we want to pull
data
using an advanced filter and have it end up on a different sheet we have to start
the advanced filter on that destination sheet
so we're on the Top Order sheet and i'm going to select a cell that's away from those headings
so just a blank cell
down here
and then I'll go to the Data menu
and click on Filter
and click Advanced Filter
We want to copy to another location
and and i'm going to select the List Range so I'll go back to the order sheet
and just select
the entire table
The criteria range
I'll go back to Orders
and just select those two cells
and for Copy To
I want
to use these two headings
on the Top Order sheet
I'll click OK
and you can see the three orders
that we had
that were over fifteen hundred dollars