| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find Maximum date
Brilliant! all formuals worked a treat and I thank you Ron and Bob for your
assistance and quick response Regrads/sgl "sgl" wrote: I have the followinig three columns Index DateFrom DateTo 1 28 Apr 04 28 Sep 04 2 28 Sep 04 28 Jan 05 3 28 Sep 04 29 Mar 05 4 29 Mar 05 28 Jul 05 5 28 Jul 05 30 Jun 06 I want to obtain the MAX date in the DateTo column that is nearest to 1 Jan 05 which value resides in cell A1. This value is the result of another INDEX/MATCH formula. I have used the following formula (array Ctrl+Shift) obtained from this Discussion Group ={MAX(IF(DateTo<=A1,Index,0))} The result I get is 28 Sep 04 Index 1, whereas I want 28 Jan 05 with Index 2. Many thanks to you all Regards/sgl |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find a date in a list | Excel Discussion (Misc queries) | |||
| Another Date issue. | Excel Worksheet Functions | |||
| how can i find a specific date of a database | Excel Discussion (Misc queries) | |||
| search for latest date | Excel Worksheet Functions | |||
| find date in Col A corresponding to min value in Col B | Excel Worksheet Functions | |||
Threaded Mode
