Thread: Array formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sandy Sandy is offline
external usenet poster
 
Posts: 355
Default 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