i using excel, , have 2 columns laid out so:
column - contains dates
column b - contains numbers
i using array formula scan column b find occurrences of numbers > 6 , checking if match or no match.
then there match checking column recent date corresponds value in column b.
i doing using following array formula:
{=if(countif(b:b,">6")=0,"no match",max(if(b:b=">6",a:a)))} i counting number of days today in value has occurred.
=iferror(today()-m1,0) i getting error message saying there error in formula following formula
{=if(countif(b:b,">6")=0,"no match",max(if(b:b=">6",a:a)))}
you can use standard non-array formula putting index function work max function.
=max(index($a:$a*($b:$b>6), , )) that returned date serial number 42,125. have format date.
