Return an array of data based on range of date

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
 
S

Shane Devenshire

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?
 
K

Ken King

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top