| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Query Items Listed During a Specific Time Period
Column A has a list of Items and Column B has the date that each item
was put into the spreadsheet. I need to populate a list of all the items that have been added over the past week. For example, Columm A has items Peach, Pear, & Plum. Column B has respective dates 5/1, 7/2, 7/5. On another worksheet, when I type in 7/6, I want Pear and Plum to appear since they were added within the last 7 days of 7/6. Is there any way to run such a query? maybe using VBA? Please help. Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting instances of specific times in fields with date and time | Excel Worksheet Functions | |||
| Edit query takes a long time | Excel Worksheet Functions | |||
| Time calculation for a givenn period | Excel Discussion (Misc queries) | |||
| How do I open to a specific worksheet every time? | New Users to Excel | |||
| Count items between specific hours on a matching date | Excel Worksheet Functions | |||
Linear Mode
