Formula excel mencari data yang hilang

Formula yang digunakan
pada Cel B2:
=SUBSTITUTE(SUMPRODUCT(--ISERROR(FIND(ROW(1:9),A2)),10^{9;8;7;6;5;4;3;2;1},ROW(1:9)),0,"")
Sumber:
milis belajar excel
Sumber:
milis belajar excel
Category: Tutor Excel
Home � Tutor Excel � Formula excel mencari data yang hilang
Category: Tutor Excel
About GalleryBloggerTemplates.com:
GalleryBloggerTemplates.com is Free Blogger Templates Gallery. We provide Blogger templates for free. You can find about tutorials, blogger hacks, SEO optimization, tips and tricks here!
Related posts:
If you enjoyed this article, subscribe to receive more just like it.
Mohon kiranya dapat berpartisipasi memberikan komentar pada postingan yang anda baca. Terimakasih
0 comments