Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
Putting list items under appropriate date?
Maybe this isn't a job for Excel - if you know of a program that's
built for this, I'd appreciate the tip! In XL2000, I'd like to make a table of items: Col A = Description Col B = Date Due Col C = Date Completed In Cols F-L, I'll create a calendar, giving each day four or five rows. The first row of each set would have the date. A formula in the rows under the date would find all matching dates in Col B and return the description from Col A. That sounds like VLOOKUP, yes? The table will not be in any kind of order, and will vary in length from month to month. Dates will appear more than once, possibly but not necessarily consecutive. Won't VLOOKUP just return the first value it comes to and ignore multiple entries? Ed |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need a formula that change all date by putting in one date | Excel Worksheet Functions | |||
Data Validation: items in one list relate to items in another | Excel Programming | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Items in disabled items list - unknown excel addins causing probs | Excel Programming | |||
Putting items from list box multi-select onto worksheet | Excel Programming |