Index Match VS Vlookup (bag.1)

 

Rumus =index(colombox(kode,kodeacuan,0),1)

Source:https://youtube.com/shorts/_T0h2s3BMhY?si=ExEC2NwofwT05k23

Rumus Index Match better Vlookup

 

Rumus =index(cells dicari,match(colom1&colom2,colom3&colom4))

Source: https://youtu.be/iYKpgUNnV5E?si=OS_3OCihg22mcWsw

Memisahkan Kata Kalimat dalam Kolom Excel

 

Rumus : 

Data - Flash Fill

Ctrl + E (otomatis tercopy kebawah)

Source Links:

https://youtube.com/shorts/s2flXluMaVs?si=7MY196cBIl2tm0bV

https://youtube.com/shorts/w8wMjcUZZRA?si=YZaWXTerJ6KmkmIX