I would like to create an array formula (in order to use the result to
multiply other arrays) to populate a table as below with the answers as
below (eg {0,1,1})


jan05 feb05
mar05 apr05 may05
mar 05 feb05 apr05 {0,0,0} {0,1,0} {1,1,0}
{1,1,1} {1,1,1}
apr 05 feb05 jan05 {0,0,1} {0,1,1} {0,1,1}
{1,1,1} {1,1,1}


The formula should compare the text entries in 3 columns on the right
and check to see whether the date is less than or equal to the date in
the current column. If true (ie less than or equal to) it needs to
return a 1 in that position else 0.

Can anyone help?

Thanks


--
Ruthki
------------------------------------------------------------------------
Ruthki's Profile: http://www.excelforum.com/member.php...o&userid=24503
View this thread: http://www.excelforum.com/showthread...hreadid=383429