I queried a database and put the following three columns in an Excel
worksheet tab, Suite Number, Occupant Name and Lease Expiration Date sorted
by Lease Expiration Date then Suite Number. I have a 5-year monthly calendar
in a separate worksheet tab that I want to list Suite Number(s) and Occupant
Name(s) within each columns Expiration month for the 5-year period. I want
to use a formula or function in each column on the 5-year monthly calendar
tab to return Suite Number and Occupant Name based on the range of dates
using the column header and adjacent column i.e. 1/1/2009 to 2/1/2009.

Is there a function to return an array of data in two of the three columns,
Suite Number and Occupant Name based on the month in the third Expiration
Date column?
Ken

Hi,

Show us a sample of the way the 5-Year calendar looks?

Is it one long row 1/1/2008....12/1/2014
or is is
Jan ... Dec
2009
2010

And what are the actual entries in the calendar - numbers, dates, text?
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Ken King" wrote:

I queried a database and put the following three columns in an Excel
worksheet tab, Suite Number, Occupant Name and Lease Expiration Date sorted
by Lease Expiration Date then Suite Number. I have a 5-year monthly calendar
in a separate worksheet tab that I want to list Suite Number(s) and Occupant
Name(s) within each columns Expiration month for the 5-year period. I want
to use a formula or function in each column on the 5-year monthly calendar
tab to return Suite Number and Occupant Name based on the range of dates
using the column header and adjacent column i.e. 1/1/2009 to 2/1/2009.

Is there a function to return an array of data in two of the three columns,
Suite Number and Occupant Name based on the month in the third Expiration
Date column?
Ken

The calendar is based on month

01/01/2009 02/01/2009 03/01/2009 ect.

"Shane Devenshire" wrote:

Hi,

Show us a sample of the way the 5-Year calendar looks?

Is it one long row 1/1/2008....12/1/2014
or is is
Jan ... Dec
2009
2010

And what are the actual entries in the calendar - numbers, dates, text?
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Ken King" wrote:

I queried a database and put the following three columns in an Excel
worksheet tab, Suite Number, Occupant Name and Lease Expiration Date sorted
by Lease Expiration Date then Suite Number. I have a 5-year monthly calendar
in a separate worksheet tab that I want to list Suite Number(s) and Occupant
Name(s) within each columns Expiration month for the 5-year period. I want
to use a formula or function in each column on the 5-year monthly calendar
tab to return Suite Number and Occupant Name based on the range of dates
using the column header and adjacent column i.e. 1/1/2009 to 2/1/2009.

Is there a function to return an array of data in two of the three columns,
Suite Number and Occupant Name based on the month in the third Expiration
Date column?
Ken

I can email the data file if you prefer since my requirement have change
slightly.

"Ken King" wrote:

The calendar is based on month

01/01/2009 02/01/2009 03/01/2009 ect.

"Shane Devenshire" wrote:

Hi,

Show us a sample of the way the 5-Year calendar looks?

Is it one long row 1/1/2008....12/1/2014
or is is
Jan ... Dec
2009
2010

And what are the actual entries in the calendar - numbers, dates, text?
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Ken King" wrote:

I queried a database and put the following three columns in an Excel
worksheet tab, Suite Number, Occupant Name and Lease Expiration Date sorted
by Lease Expiration Date then Suite Number. I have a 5-year monthly calendar
in a separate worksheet tab that I want to list Suite Number(s) and Occupant
Name(s) within each columns Expiration month for the 5-year period. I want
to use a formula or function in each column on the 5-year monthly calendar
tab to return Suite Number and Occupant Name based on the range of dates
using the column header and adjacent column i.e. 1/1/2009 to 2/1/2009.

Is there a function to return an array of data in two of the three columns,
Suite Number and Occupant Name based on the month in the third Expiration
Date column?
Ken