Berikut adalah option untuk nombor running
| PILIHAN | CELL | FORMULA | CATATAN |
| Option1 | – | Manual | |
| Option2 | D3 | =D2+1 | Cell ditambah dengan cell sebelum |
| Option3 | E1 | =ARRAYFORMULA(if(row(B:B)=1,”Bil”,IF(B:B=””,””,ROW(B:B)-1))) | |
| Option4 | F1 | =ARRAYFORMULA(if(row(B:B)=1,”Bil”,IF(B:B=””,””,ROW(B:B)-1))) | |
| Option5 | F2 | =ARRAYFORMULA(if(B2:B=””,””,SEQUENCE(rows(B2:B),1))) | |
| Option6 | G1 | ={“BIL”;ArrayFormula(if(B2:B=””,””,SEQUENCE(rows(B2:B),1)))} | |
| Option7 | H1 | ={“BIL”;ArrayFormula(IF(B2:B=””,””,row(B2:B)-(row(B2)-1)))} |
Nota: Tukar cell mengikut Cell yand diperlukan……