I was trying to make these {"MOOE-LIQUIDATED","MOOE-DOWNLOADED","GAD-LIQUIDATED","CANCELLED"} to be inputted with Cell reference on A1, A2, A3, A4 but it gives me error if I change it.
PHP Code:
{= IFERROR ( INDEX ( MOOE ! $A $ 5 : $DA $ 600 , SMALL (IF(( INDEX ( MOOE ! $A $ 5 : $DA $ 600 ,, 9 )= $D $ 8 )*( INDEX ( MOOE ! $A $ 5 : $DA $ 600 ,, 1 )>= $D $ 9 )*( INDEX ( MOOE ! $A $ 5 : $DA $ 600 ,, 1 )<= $F $ 9 )*( INDEX ( MOOE ! $A $ 5 : $DA $ 600 ,, 48 )={ "MOOE-LIQUIDATED" , "MOOE-DOWNLOADED" , "GAD-LIQUIDATED" , "CANCELLED" }),MATCH( ROW ( MOOE ! $A $ 5 : $A $ 600 ), ROW ( MOOE ! $A $ 5 : $A $ 600 )), "" ), ROWS ( $A $ 1 : A1 )), COLUMNS ( $A $ 1 : A1 )), "" )}
into
PHP Code:
{= IFERROR ( INDEX ( MOOE ! $A $ 5 : $DA $ 600 , SMALL (IF(( INDEX ( MOOE ! $A $ 5 : $DA $ 600 ,, 9 )= $D $ 8 )*( INDEX ( MOOE ! $A $ 5 : $DA $ 600 ,, 1 )>= $D $ 9 )*( INDEX ( MOOE ! $A $ 5 : $DA $ 600 ,, 1 )<= $F $ 9 )*( INDEX ( MOOE ! $A $ 5 : $DA $ 600 ,, 48 )={ A1 , A2 , A3 , A4 }),MATCH( ROW ( MOOE ! $A $ 5 : $A $ 600 ), ROW ( MOOE ! $A $ 5 : $A $ 600 )), "" ), ROWS ( $A $ 1 : A1 )), COLUMNS ( $A $ 1 : A1 )), "" )}
That portion means that either of the following somewhat related to OR function.
Bookmarks