Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Array formula
Hello Folks,
I am using the following array formula: {INDEX(C$2:C$8800,MATCH(1,IF($A$2:$A$88800=$Y2,IF( $S$2:$S$8800=$AA2,1)),0))} The formula returns a Date/Time and I would like to add 1 hour to the return. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
Array formula | Excel Discussion (Misc queries) | |||
(array?) formula | Excel Discussion (Misc queries) | |||
Array Formula - using LEFT("text",4) in formula | Excel Worksheet Functions | |||
Array Formula | Excel Worksheet Functions |