I would like to filter a listin Excel to pick out all vehicles sold in the
range of $10,000-$20,000 Does anyone know how I can do that? I am in school
and suppose to figure it out by myself but I can't find anything helpful in
the Help Section of Excel.
Thanks,
TJ

Hi TJ

You can use AutoFilter
Choose custom in the dropdown

--
Regards Ron de Bruin
http://www.rondebruin.nl


"TJ" wrote in message ...
I would like to filter a listin Excel to pick out all vehicles sold in the
range of $10,000-$20,000 Does anyone know how I can do that? I am in school
and suppose to figure it out by myself but I can't find anything helpful in
the Help Section of Excel.
Thanks,
TJ

Thanks but I have to use the Advanced filter feature. TJ

"Ron de Bruin" wrote:

Hi TJ

You can use AutoFilter
Choose custom in the dropdown

--
Regards Ron de Bruin
http://www.rondebruin.nl


"TJ" wrote in message ...
I would like to filter a listin Excel to pick out all vehicles sold in the
range of $10,000-$20,000 Does anyone know how I can do that? I am in school
and suppose to figure it out by myself but I can't find anything helpful in
the Help Section of Excel.
Thanks,
TJ

Why do you have to use the Advanced Filter? The Custom AutoFilter will do
this, assuming all the prices are in the same column.
Just choose Custom.
Then set the first condition to greater than or equal to 10000.
Make sure And is chosen (instead of Or).
For the second condition, set it to is less than or equal to 20000.

If you must use the Advanced Filter, you can do this.
For the Criteria range, put =AND(B2=10000,B2<=20000), assuming that the
prices are in Column B, with the first price in B2.
Then, when you run the Advanced Filter, choose the cell above the formula
and the formula as your criteria.
For an explanation of this technique, see
http://www.contextures.com/xladvfilter02.html

--
tj


"TJ" wrote:

Thanks but I have to use the Advanced filter feature. TJ

"Ron de Bruin" wrote:

Hi TJ

You can use AutoFilter
Choose custom in the dropdown

--
Regards Ron de Bruin
http://www.rondebruin.nl


"TJ" wrote in message ...
I would like to filter a listin Excel to pick out all vehicles sold in the
range of $10,000-$20,000 Does anyone know how I can do that? I am in school
and suppose to figure it out by myself but I can't find anything helpful in
the Help Section of Excel.
Thanks,
TJ

Because its for a computer college computer class. I know the Autofilter
would do the same thing but I'm suppose to figure out how to do it using the
Advanced Filter. I hate this class by the way.
Tj

"tjtjjtjt" wrote:

Why do you have to use the Advanced Filter? The Custom AutoFilter will do
this, assuming all the prices are in the same column.
Just choose Custom.
Then set the first condition to greater than or equal to 10000.
Make sure And is chosen (instead of Or).
For the second condition, set it to is less than or equal to 20000.

If you must use the Advanced Filter, you can do this.
For the Criteria range, put =AND(B2=10000,B2<=20000), assuming that the
prices are in Column B, with the first price in B2.
Then, when you run the Advanced Filter, choose the cell above the formula
and the formula as your criteria.
For an explanation of this technique, see
http://www.contextures.com/xladvfilter02.html

--
tj


"TJ" wrote:

Thanks but I have to use the Advanced filter feature. TJ

"Ron de Bruin" wrote:

Hi TJ

You can use AutoFilter
Choose custom in the dropdown

--
Regards Ron de Bruin
http://www.rondebruin.nl


"TJ" wrote in message ...
I would like to filter a listin Excel to pick out all vehicles sold in the
range of $10,000-$20,000 Does anyone know how I can do that? I am in school
and suppose to figure it out by myself but I can't find anything helpful in
the Help Section of Excel.
Thanks,
TJ