autofilters

blondiechick

Board Regular
Joined
Oct 13, 2006
Messages
60
Return to the sort by title. Using a Custom AutoFilter, display only records for the color of the car whose is either black or white, and list that cars model year that is after 1979.

I tried doing this. I made a custom AutoFilter for the color and that sorted great. Then I selected 1979, and it only showed the black color, it left the white out. What did I do wrong?

The I did the year first, and then I made a list for black and white. Then, no data showed.

Am I missing something?
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

shippey121

Well-known Member
Joined
Mar 21, 2006
Messages
1,001
i take it your colours are in one column and the years in another, you will need to do two custom filters to achive what you require

first click the colour column and select custom, the enter Black or White click ok, this will filter out the black and white cars, the select the year column, click custom and enter => 1979 this will filter again on the years

HTH
 

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
Hi blondiecick:

You may also use AdvancedFilter as illustrated in the following ...
Book5
ABCDEFG
1dataBase
2criteriaFALSE
3copy_to
4
5
6CarColorCarYearCarColorCarYear
7Red1979White1980
8Black1978Black1983
9White1980White1984
10Red1982
11White1978
12Black1983
13White1984
14Orange1980
15
Sheet1 (2)
 

Forum statistics

Threads
1,136,655
Messages
5,677,015
Members
419,668
Latest member
DharmaK

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top