drop down list variable

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list of information in contained in A1:R500. Some rows are blank.
Each row contains the date the job was scheduled. Cell T1 contains the
current date. What I need to do is examine the data and extract only the
rows that fall within a 14 day period prior to this date. Then create a drop
down list based on the result.
Thanks for the help,
Steve
 
You say..
Some rows are blank.
Each row contains the date

hummmm...
We aren't off to a good start..

So which is it?
 
Some rows are COMPLETELY blank. if a row is missing a date, there is no
other info in that row. The rows that contain a date in the 14 day range
will need to appear on the drop down list.
 

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

Similar Threads

Drop Down List Contains the List Header Row 1
Filtered drop down list 2
Data validation list using filtered range 3
Drop Down List 7
Drop down list 1
Conditional drop down list 3
Array Substitution Based on Drop Down List 1
Use first day of month formula in a drop down list 3

Back
Top