Kwai Logo
Kwai User Avatar
Ini dia salah satu fungsi yang paling powerful di Excel, ya. Namanya adalah XLOOKUP. Jadi, bayangkan saja kalau kita ingin mencari, ingin menelusuri data penjualan dari si ID-9, bagaimana caranya? Kita akan menggunakan XLOOKUP, XL dan tab Lalu, Excel akan bertanya, "oke, nilai pencarian apa nih? Apa yang ingin kita cari?" "Oh, carikan D2," ya. D2 itu dicarinya di mana? Kamu langsung ke kolom A, dan mulai mencari nomor urutnya. Di sini, ID-9 itu ternyata ada di nomor urut ke-10. Setelah itu, Exc...
Like
1
Download
Loading
kwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwai