autofilters

[blondiechick]

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?

 

[shippey121]

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]

Hi blondiecick:

You may also use AdvancedFilter as illustrated in the following ...

Book5
	A	B	C	D	E	F	G
1		dataBase
2		criteria			FALSE
3		copy_to
4
5
6		CarColor	CarYear		CarColor	CarYear
7		Red	1979		White	1980
8		Black	1978		Black	1983
9		White	1980		White	1984
10		Red	1982
11		White	1978
12		Black	1983
13		White	1984
14		Orange	1980
15
Sheet1 (2)

 

[blondiechick]

Thank you both!
It worked = )