I am using this formula in Google sheets and it is running from cell CQ22:CQ605. Just wondering if there is a fast maybe Array formula way of calculating all of this. Help is much appreciated. Thanks!
=IF(AND(INDIRECT("Data!E"&13+$F$7+ROW()-21)>=$CQ$17,INDIRECT("Data!E"&13+$F$7+ROW()-21)<=$CQ$16),INDIRECT("Data!E"&13+$F$7+ROW()-21),"")
Aucun commentaire:
Enregistrer un commentaire