View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default Filter for Decade Birthdays

try a helper column
=mod(year(birthday),10)
then use auto filter for 7 (for this year)

"Amy" wrote:

I have a list of Clients with birthdays, but only want to send gifts to
clients with decade birthdays this year, (40, 50, 60 etc). I am not sure how
to "pull out" the people with the right year of birth from the entire list.

Thanks in advance!

Amy