AUTO-NOMBOR MS EXCEL

Assalamualaikum...
Ni salah satu cara kita nak menjimatkan masa semsa menaip data yg setinggi gunung-ganang di banjaran Himalaya!!

klik foto untuk paparan lebih jelas.

Formula yg ada dalam screenshot di atas:-


AUTO-NUMBERING (CARA 1)
=IF(C7=0,"",1)
=IF(C8=0,"",B7+1)
=IF(C9=0,"",B8+1)
=IF(C10=0,"",B9+1)
=IF(C11=0,"",B10+1)
=IF(C12=0,"",B11+1)
=IF(C13=0,"",B12+1)
=IF(C14=0,"",B13+1)
=IF(C15=0,"",B14+1)
=IF(C16=0,"",B15+1)
=IF(C17=0,"",B16+1)
=IF(C18=0,"",B17+1)
=IF(C19=0,"",B18+1)
=IF(C20=0,"",B19+1)
=IF(C21=0,"",B20+1)
=IF(C22=0,"",B21+1)
=IF(C23=0,"",B22+1)
=IF(C24=0,"",B23+1)
=IF(C25=0,"",B24+1)


AUTO-NUMBERING(CARA 2)
=IF(K6=0,"",1)
=IF(K7=0,"",IF(K6=0,1,J6+1))
=IF(K8=0,"",IF(K7=0,1,J7+1))
=IF(K9=0,"",IF(K8=0,1,J8+1))
=IF(K10=0,"",IF(K9=0,1,J9+1))
=IF(K11=0,"",IF(K10=0,1,J10+1))
=IF(K12=0,"",IF(K11=0,1,J11+1))
=IF(K13=0,"",IF(K12=0,1,J12+1))
=IF(K14=0,"",IF(K13=0,1,J13+1))
=IF(K15=0,"",IF(K14=0,1,J14+1))
=IF(K16=0,"",IF(K15=0,1,J15+1))
=IF(K17=0,"",IF(K16=0,1,J16+1))
=IF(K18=0,"",IF(K17=0,1,J17+1))
=IF(K19=0,"",IF(K18=0,1,J18+1))
=IF(K20=0,"",IF(K19=0,1,J19+1))
=IF(K21=0,"",IF(K20=0,1,J20+1))
=IF(K22=0,"",IF(K21=0,1,J21+1))
=IF(K23=0,"",IF(K22=0,1,J22+1))
=IF(K24=0,"",IF(K23=0,1,J23+1))