K
Ken King
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
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