Membuat Penomoran Surat Otomatis pada Excel

Creating Automatic Letter Numbering in Excel. This video tutorial explains how to use formulas in Excel to automatically create letter numbering, complete with the formatting. The goal is to simplify your work and minimize errors in letter numbering. Hopefully this is helpful :) Lab Files: https://arhiez.net/20200505 --- The formulas I used in this video: • D5=TEXT(1,"000") • D6=TEXT(D5+1,"000") • E5=VLOOKUP(B5,Code!$B$2:$C$6,2,FALSE) • F5=VLOOKUP(C5,Code!$B$10:$C$14,2,FALSE) • G5=ROMAN(MONTH(A5),0) • H5=YEAR(A5) • I5=IFERROR(D5&"/"&E5&"-"&F5&"/"&G5&"."&H5,"") ----- Follow Native Enterprise for IT Training and Coaching information For your agency or company:   / native.enterprise     / native.enterprise   Native Enterprise Professional IT Training Provider https://ntv.co.id • [email protected] -- Excel Formulas Excel Formulas Excel Functions Excel Tutorials Excel Guides Learn Excel How to Excel Excel Tips Excel Training Excel Training VLOOKUP IFERROR Letter Numbering #excel #formula #function #tutorial #guide #learn #office #microsoft -- Background image for video intro and thumbnail picture: Created by tirachard (www.freepik.com)