hai Firman,
di D3 ketik
="PEND"&YEAR(C3)&TEXT(SUM(--(YEAR($C$3:C3)=YEAR(C3))),"0000")
akhiri dengan ctrl shift enter sehingga menghasilkan
{="PEND"&YEAR(C3)&TEXT(SUM(--(YEAR($C$3:C3)=YEAR(C3))),"0000")}copy ke bawah thank you and regards, - abimono -
autonumber.xls
Description: MS-Excel spreadsheet
