| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Need to find oldest date in ever changing list.
My worksheet has Date.Ordered in COL-A and Date.Filled in COL-F. I can
find the oldest date in Date.Ordered by using the SMALL function. However, when I fill that order, I need to know the next oldest date to be filled. I cannot figure out how to make the formula look at only unfilled orders (i.e where a date does not exist in Date.Filled). Does anyone have a solution? -- Message posted via http://www.officekb.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I find duplicates in a list | Excel Discussion (Misc queries) | |||
| Detecting Oldest Date On Spreadsheet | Excel Discussion (Misc queries) | |||
| How do I find out what items are in one list but not in another l. | Excel Discussion (Misc queries) | |||
| How can I sum information in a list with a date range? | Excel Worksheet Functions | |||
| find date in Col A corresponding to min value in Col B | Excel Worksheet Functions | |||
Threaded Mode
