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
siti
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.
Aladin
-------------------------
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 ?
Dave
OzGrid Business Applications
Posted by siti on April 15, 2001 4:13 PM
tx a heap Aladin, all..:)
