MrExcel Publishing
Your One Stop for Excel Tips & Solutions

repost:advance filter

Posted by siti on April 15, 2001 10:03 AM

Dear Mark and Dave

The advance filter works just fine. Referring back to the names and birtdate example, how do i filter both month and year as well? For example, i want to filter those born in 1962 and in the month of March? TIA

Posted by Aladin Akyurek on April 15, 2001 12:09 PM


As a follow-up on Mark's suggestion:

Place the target year in some cell a cell that's not within your data list range (say N1) and target month as number (March=3) in another (say N2).

=AND(YEAR(B2)=$N$1,MONTH(B2)=$N$2) and copy down.



Posted by Dave Hawley on April 15, 2001 3:08 PM

Hi siti

Glad it worked :o)

Have you looked at using Excels normal Filter for filtering out your dates? Using the "Custom" option with some Wildcard characters may be easier ?

OzGrid Business Applications

Posted by siti on April 15, 2001 4:13 PM

tx a heap Aladin, all..:)