Ukuze wandise iifomula kuzo zonke iikholamu ngaphakathi kuGoogle AmaSpredish, sicebisa ukuba sisebenzise umsebenzi we- ARRAYFORMULA . Ngelishwa, oku akusebenzi ngokudibeneyo neminye imisebenzi ebalulekileyo enje nge- QUERY okanye INDIRECT , yiyo loo nto kukho inkqubo egqibeleleyo yomgaqo ngoncedo lweGoogle Apps Script okanye, kungenjalo, ukukopa ngesandla ifomula ukuya kumgca wokugqibela.
Ngenye indlela, sakha umsebenzi oncedisayo omncinci okwahlukileyo okwexeshana okhangela iifomula kumgca 2 wazo zonke iiwekhishithi kwaye ngokuzenzekelayo uzikopishe ukuphela kwetafile. Iifomula ze-ARRAYFORMULA azihoywa ngokuzenzekelayo. Uyifaka yonke into ngeZixhobo> Umhleli weSkripthi kwaye uyiyeke iqhubeke nexesha-ilawulwa i-1x ngomzuzu ngokuHlela> Ukucwangciswa kweprojekthi yangoku:
f9c221988a2b56958ffb5b0649bbdf27