#1
|
|||
|
|||
Searching dates to create lists
Hi. I have a spreadsheet that contains names in column C and dates in column G. I'm looking for a macro or formula that checks all the dates in column G and lists the corresponding names for those dates that are earlier than todays date. I would like the output to appear in a seperate area within the same spreadsheet, if possible. Is there an easy, straight forward way of performing this task? |
#2
|
|||
|
|||
Hi,
this is possible to solve via "MS Query", which is built-in in Excel. It is not too easy to explain. I attach a sheet that should work for you. You can add your data to this sheet! Do not change anything in the sheet "Result". Try to change records in the sheet "Data" and you will see that the "result" sheet changes! Kind regards Bjorn |
#3
|
|||
|
|||
Sorry,
due to different circumstances this solution doesn't work correctly. Kind regards Bjorn |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
MS Excel 2004 for Mac - copying dates between documents | BCRenton | Excel | 4 | 11-10-2009 07:28 AM |
Searching Outlook folders not working | cltaylor | Outlook | 0 | 08-31-2009 10:28 AM |
Searching another persons contacts | Hendo313 | Outlook | 1 | 07-10-2009 09:03 AM |
Adding dates | mkkram | Word | 0 | 11-27-2006 09:18 AM |
Drop Down Lists | Browett | Excel | 0 | 12-19-2005 04:20 PM |