Need to Select Individual Records Based on Birthdays in Current Mo
 

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.

Need to Select Individual Records Based on Birthdays in Current Mo
 

Assuming birthdates are in column C

In a helper column enter =MONTH(C1)

Copy down.

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

F5SpecialVisible CellsOK

Copy and paste the visible cells to somewhere.


Gord Dibben MS Excel MVP

On Wed, 7 Oct 2009 13:53:02 -0700, PlarfySoober
wrote:

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.

Need to Select Individual Records Based on Birthdays in Curren
 

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.

"Gord Dibben" wrote:

Assuming birthdates are in column C

In a helper column enter =MONTH(C1)

Copy down.

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

F5SpecialVisible CellsOK

Copy and paste the visible cells to somewhere.


Gord Dibben MS Excel MVP

On Wed, 7 Oct 2009 13:53:02 -0700, PlarfySoober
wrote:

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.

Need to Select Individual Records Based on Birthdays in Curren
 

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


On Tue, 20 Oct 2009 11:14:01 -0700, PlarfySoober
wrote:

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.

"Gord Dibben" wrote:

Assuming birthdates are in column C

In a helper column enter =MONTH(C1)

Copy down.

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

F5SpecialVisible CellsOK

Copy and paste the visible cells to somewhere.


Gord Dibben MS Excel MVP

On Wed, 7 Oct 2009 13:53:02 -0700, PlarfySoober
wrote:

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.

Need to Select Individual Records Based on Birthdays in Curren
 

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 F5SpecialVisible CellsOK.

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

Thanks again.

"Gord Dibben" wrote:

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


On Tue, 20 Oct 2009 11:14:01 -0700, PlarfySoober
wrote:

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.

"Gord Dibben" wrote:

Assuming birthdates are in column C

In a helper column enter =MONTH(C1)

Copy down.

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

F5SpecialVisible CellsOK

Copy and paste the visible cells to somewhere.


Gord Dibben MS Excel MVP

On Wed, 7 Oct 2009 13:53:02 -0700, PlarfySoober
wrote:

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.



.