Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Googled all over and haven't been able to find a solution- thanks in
advance for any help! In Col A I have a list of items that are due for arrival; in Col B I have the corresponding arrival dates. List must remain unsorted (sorted would be too easy!) Col A Col B Monkey 12/1/07 Cat 1/15/08 Cow 11/21/07 Monkey 11/18/07 Peanut 1/30/08 Monkey 12/24/07 Cow 11/14/07 In Col C I need a formula to drag down that will give the earliest date available, so for Monkey the date 11/18/07 would fill in for every instance of Monkey; Cow would get 11/14/07. Is it possible to set column D with a formula that would give the next< possible available date? So for Monkey, the answer would be 12/1/07? Thanks again! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find closest future date from list ... | Excel Discussion (Misc queries) | |||
Closest value lookup? | Excel Worksheet Functions | |||
How can I match a calculated date to closest date from a list? | Excel Worksheet Functions | |||
Lookup Closest Value | Excel Worksheet Functions | |||
finding a date/time in a list that is closest to an existing date/ | Excel Discussion (Misc queries) |