betul, cara spt itu (menggabung bersyarat) jika harus hanya dengan formula biasa = "tidak bagus"
atau: mempersulit diri sendiri
tapi kalau boleh pakai udf, formulanya menjadi pendek sekali; tinggal atulis
=ConcatIf(B2:AA2;$B$1:$AA$1;"-")
2010/11/7 abimono <abimono@xl-mania.com>
>
> hai novi krisdiyanto
>
> walau ini bukan cara menampilkan data yang baik, saya coba jawab:
> di AB2:
> =SUBSTITUTE(TRIM(IF(B2>0,B$1,"")&" "&IF(C2>0,C$1,"")&"
> "&IF(D2>0,D$1,"")&" "&IF(E2>0,E$1,"")&" "&IF(F2>0,F$1,"")&"
> "&IF(G2>0,G$1,"")&" "&IF(H2>0,H$1,"")&" "&IF(I2>0,I$1,"")&"
> "&IF(J2>0,J$1,"")&" "&IF(K2>0,K$1,"")&" "&IF(L2>0,L$1,"")&"
> "&IF(M2>0,M$1,"")&" "&IF(N2>0,N$1,"")&" "&IF(O2>0,O$1,"")&"
> "&IF(P2>0,P$1,"")&" "&IF(Q2>0,Q$1,"")&" "&IF(R2>0,R$1,"")&"
> "&IF(S2>0,S$1,"")&" "&IF(T2>0,T$1,"")&" "&IF(U2>0,U$1,"")&"
> "&IF(V2>0,V$1,"")&" "&IF(W2>0,W$1,"")&" "&IF(X2>0,X$1,"")&"
> "&IF(Y2>0,Y$1,"")&" "&IF(Z2>0,Z$1,"")&" "&IF(AA2>0,AA$1,"")&" "),"
> ","-")
>
> copy sampai bawah
> thank you and regards,
> - abimono -
>
>
>
> 2010/11/5 Novi Krisdiyanto <novi@domusindo.com>
> > Pakar-pakar Excel yang budiman,
> > Saya mengalami kesulitan dalam menggabungkan nomor stuff, jika di cell yang blok kuning nilainya lebih dari 0.
> > Mohon bantuannya, bagaimanakah formulasinya dan terimakasih sebelumnya.
> > Hormat saya
> > Novi
| woooohoooo... tembus 16,000 members! nggg... gimana kalo tembus |
| 20,000 members kita kopi darat di bunderan HI? :D :D :D |
| http://www.facebook.com/group.php?gid=37671048001&ref=mf |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message, melecehkan, tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan winzip jika perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/ |
+-------------------------------------------------------------------+
| Berikan testimoni di : http://www.friendster.com/xlmania atau... |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html |
+-------------------------------------------------------------------+
| Message lama ada di : |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id] |
| http://www.mail-archive.com/xl-mania@yahoogroups.com |
+-------------------------------------------------------------------+
Nenhum comentário:
Postar um comentário