Need to Select Individual Records Based on Birthdays in Current Mo

  • Thread starter Thread starter PlarfySoober
  • Start date Start date
P

PlarfySoober

That sort of says it. I need to create a list, probably on the same sheet,
with the names & birthdays of everybody whose birthday, e.g., falls in
October.

Trying to do it by hand is embarrassingly inaccurate.

Any suggestions would certainly be welcome.

Don.
 
Assuming birthdates are in column C

In a helper column enter =MONTH(C1)

Copy down.

Autofilter on Month number..........9 is October.

F5>Special>Visible Cells>OK

Copy and paste the visible cells to somewhere.


Gord Dibben MS Excel MVP
 
Gord,

Thanks for the reply. As a new user, though, I have some questions that are
probably pretty basic:

By "helper column" you mean an otherwise blank column meant tonly to contain
a sort of filter?

By "copy down", you mean approximately the number of individuals I expect to
have once the filter is applied?

Thanks.
 
A helper column is a blank column in which you enter formulas to return
sortable/filterable results.

Copy down means you place the formula =MONTH(C1) in say D1

Double-click on the fill handle........small black square at righthand
bottom corner of D1

This will copy the formula down as far as you have data in column C.

The formula will increment to C2, C3, C4 etc. as it fills down.

The month numbers will be returned from the formulas.

You then autofilter on that column for the number 8, which is October.


Gord
 
Gord,

OK, your explanation is detailed and I got that far.

After Autofiltering, I had a column with the numbers of the months in it. So
far, so good.

Then, I touched F5>Special>Visible Cells>OK.

But nothing happened. Was I supposed to block something, or something like
that?

Thanks again.
 
Back
Top