samedi 4 janvier 2020

Needing Array Formula Please

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