Re: [ITCENTER] formula di excel
validation, seperti halna vlookup dll bisa diambil dari file lain. -sol- On 10/29/07, Anton Setiawan <[EMAIL PROTECTED]> wrote: > > Met pagi semuanya, > begini mas/mbak/om/tante, semisal saya punya data excel contoh : > 1. mie goreng > 2. mie telur > 3. telur ayam > terus pas saya ketik "te" langsung keluar pilihan menu (telur ayam)dari > data yg saya punya. gimana ya cara bikin formulanya ? > > nb : data saya koneksikan dengan "validation data" > trus da lgi nich, apa validation data hanya bisa di kases dalam 1 sheet yg > sama saja? bagaimana klo datanya ada di lain file excel? tolongin donk... > > thx be4 > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed] -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ITCENTER/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/ITCENTER/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [ITCENTER] Formula di Excel (problem solved)
oh...sudah komplit sekali penjelasan nya pak.baru ngeh saya
sekarang.
Matur nuwun,
Setyo Suhartanto wrote:
>Itu "array formula" Pak, jadi nantinya akan muncul tanda {...} pada formula
>yang sebelumnya kita tulis.
>
>Prosesnya sendiri, excel akan melakukan pengecekan pada tiap baris (baris 2
>sampai 12)
>Ada proses "perkalian" (mirip logika AND) pada pengecekan tsb.
>
>A2*B2="L" --> Jika B2 berisi karakter "L" maka nili A2 diambil, jika tidak
>maka A2 dianggap 0
>A3*B3="L" --> Jika B3 berisi karakter "L" maka nili A3 diambil, jika tidak
>maka A3 dianggap 0
>dst...
>
>Nilai A2 sampai A12 itu yang kemudian dijumlahkan oleh fungsi SUM diawal.
>
>
>
>
>
--
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia
Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED]
:: Hapus bagian yang tidak perlu (footer, dst) saat reply! ::
## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ##
$$ Iklan/promosi : www.itcenter.or.id/sponsorship $$
[@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ITCENTER/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
Re: [ITCENTER] Formula di Excel
Kayak gini bukan pak ?
A B
1 20 K
2 25 K
3 225000 L
4 30 K
5 40 L
6 225000 L
7 275000 K
8 30
9 245000
10 30 K
11 325000 L
K 1325000
=SUMIF($B$1:$B$11,A13,$A$1:$A$11)
L 1175000 =SUMIF($B$1:$B$11,A14,$A$1:$A$11)
- Original Message -
From: "Setyo Suhartanto" <[EMAIL PROTECTED]>
To:
Sent: Thursday, September 07, 2006 9:37 PM
Subject: Re: [ITCENTER] Formula di Excel
> Kolom A berisi Gaji
> Kolom B berisi Status
>
> A2:A12 dan B2:12 disesuaikan dengan range data
>
> =SUM((A2:A12)*(B2:B12="L"))
>
> TAHAN CTRL-SHIFT lalu ENTER
>
> Formula akhir yang muncul adalah:
>
> {=SUM((A2:A12)*(B2:B12="L"))}
>
>
>
> On 9/8/06, Wiwien Marlistyanto <[EMAIL PROTECTED]> wrote:
> >
> > Rekans, minta dolong dong.
> > saya punya permasalahan di excel nih, ceritanya gini :
> > ada 2 kolom, yaitu gaji dan status, contoh :
> >
> > Gaji status
> > 20 K
> > 25 K
> > 225000 L
> > 30 K
> > 40 L
> > 225000 L
> > 275000 K
> > 30
> > 245000
> > 30 K
> > 325000 L
> >
> > pertanyaan nya :
> > K menyatakan Kawin dan L menyatakan Lajang
> > bagaimana formula nya untuk menghitung jumlah gaji yang status nya L
> > saja ? dengan catatan kadang-kadang ada status yang masih belum di isi,
> > ini bisa dilihat dengan kosong nya kolom status.
> >
> > Mohon sekiranya bantuan dari rekan-rekan semuanya,
> >
> > Sebelum dan sesudahnya saya ucapkan terima kasih
> >
> > Salam,
> >
> > Wiwien
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
>
>
> --
> www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia
> Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED]
> :: Hapus bagian yang tidak perlu (footer, dst) saat reply! ::
> ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ##
> $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$
>
> [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>
[Non-text portions of this message have been removed]
--
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia
Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED]
:: Hapus bagian yang tidak perlu (footer, dst) saat reply! ::
## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ##
$$ Iklan/promosi : www.itcenter.or.id/sponsorship $$
[@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ITCENTER/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
Re: [ITCENTER] Formula di Excel
sorry Top Posting (masih bingung ngedit mail model gini euy :)) Bapak bisa pake rumus SUMIF syntak-nya = SUMIF(Range,Criteria,[sum_range]) Misal kolom Gaji di A dan Status di B, baris 1 - 11 rumusnya kira² begini : untuk yang L (lajang) >> "=SUMIF(B1:B11,"L",A1:A11)" untuk yang K (Kawin) >> tinggal ganti kriteria "L" dengan "K", semoga membantu Yana Nugraha - Original Message - From: Wiwien Marlistyanto To: ITCENTER@yahoogroups.com Sent: Friday, September 08, 2006 10:38 AM Subject: [ITCENTER] Formula di Excel Rekans, minta dolong dong. saya punya permasalahan di excel nih, ceritanya gini : ada 2 kolom, yaitu gaji dan status, contoh : Gaji status 20 K 25 K 225000 L 30 K 40 L 225000 L 275000 K 30 245000 30 K 325000 L pertanyaan nya : K menyatakan Kawin dan L menyatakan Lajang bagaimana formula nya untuk menghitung jumlah gaji yang status nya L saja ? dengan catatan kadang-kadang ada status yang masih belum di isi, ini bisa dilihat dengan kosong nya kolom status. Mohon sekiranya bantuan dari rekan-rekan semuanya, Sebelum dan sesudahnya saya ucapkan terima kasih Salam, Wiwien . [Non-text portions of this message have been removed] -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] :: Hapus bagian yang tidak perlu (footer, dst) saat reply! :: ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ITCENTER/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/ITCENTER/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [ITCENTER] Formula di Excel (problem solved)
Itu "array formula" Pak, jadi nantinya akan muncul tanda {...} pada formula
yang sebelumnya kita tulis.
Prosesnya sendiri, excel akan melakukan pengecekan pada tiap baris (baris 2
sampai 12)
Ada proses "perkalian" (mirip logika AND) pada pengecekan tsb.
A2*B2="L" --> Jika B2 berisi karakter "L" maka nili A2 diambil, jika tidak
maka A2 dianggap 0
A3*B3="L" --> Jika B3 berisi karakter "L" maka nili A3 diambil, jika tidak
maka A3 dianggap 0
dst...
Nilai A2 sampai A12 itu yang kemudian dijumlahkan oleh fungsi SUM diawal.
On 9/8/06, Wiwien Marlistyanto <[EMAIL PROTECTED]> wrote:
>
> Terimakasih Pak Setyo atas masukan nya, problem saya bisa teratasi :)
>
> cuman yang bikin penasaran, kok harus pake tahan CTRL - SHIFT lalu
> ENTER ya pak ??
>
> mohon pencerahan nya
>
> matur nuwun
>
> salam,
> Wiwien
>
> Setyo Suhartanto wrote:
>
> >Kolom A berisi Gaji
> >Kolom B berisi Status
> >
> >A2:A12 dan B2:12 disesuaikan dengan range data
> >
> >=SUM((A2:A12)*(B2:B12="L"))
> >
> >TAHAN CTRL-SHIFT lalu ENTER
> >
> >Formula akhir yang muncul adalah:
> >
> >{=SUM((A2:A12)*(B2:B12="L"))}
> >
> >
> >
> >
> >
>
>
>
[Non-text portions of this message have been removed]
--
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia
Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED]
:: Hapus bagian yang tidak perlu (footer, dst) saat reply! ::
## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ##
$$ Iklan/promosi : www.itcenter.or.id/sponsorship $$
[@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ITCENTER/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
Re: [ITCENTER] Formula di Excel
penjumlahan bersyarat di Excel menggunakan rumus Sumif(range;criteria;[sumrange]) - All-new Yahoo! Mail - Fire up a more powerful email and get things done faster. [Non-text portions of this message have been removed] -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] :: Hapus bagian yang tidak perlu (footer, dst) saat reply! :: ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ITCENTER/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/ITCENTER/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [ITCENTER] Formula di Excel (problem solved)
Terimakasih Pak Setyo atas masukan nya, problem saya bisa teratasi :)
cuman yang bikin penasaran, kok harus pake tahan CTRL - SHIFT lalu
ENTER ya pak ??
mohon pencerahan nya
matur nuwun
salam,
Wiwien
Setyo Suhartanto wrote:
>Kolom A berisi Gaji
>Kolom B berisi Status
>
>A2:A12 dan B2:12 disesuaikan dengan range data
>
>=SUM((A2:A12)*(B2:B12="L"))
>
>TAHAN CTRL-SHIFT lalu ENTER
>
>Formula akhir yang muncul adalah:
>
>{=SUM((A2:A12)*(B2:B12="L"))}
>
>
>
>
>
--
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia
Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED]
:: Hapus bagian yang tidak perlu (footer, dst) saat reply! ::
## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ##
$$ Iklan/promosi : www.itcenter.or.id/sponsorship $$
[@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ITCENTER/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
Re: [ITCENTER] Formula di Excel
Kolom A berisi Gaji
Kolom B berisi Status
A2:A12 dan B2:12 disesuaikan dengan range data
=SUM((A2:A12)*(B2:B12="L"))
TAHAN CTRL-SHIFT lalu ENTER
Formula akhir yang muncul adalah:
{=SUM((A2:A12)*(B2:B12="L"))}
On 9/8/06, Wiwien Marlistyanto <[EMAIL PROTECTED]> wrote:
>
> Rekans, minta dolong dong.
> saya punya permasalahan di excel nih, ceritanya gini :
> ada 2 kolom, yaitu gaji dan status, contoh :
>
> Gaji status
> 20 K
> 25 K
> 225000 L
> 30 K
> 40 L
> 225000 L
> 275000 K
> 30
> 245000
> 30 K
> 325000 L
>
> pertanyaan nya :
> K menyatakan Kawin dan L menyatakan Lajang
> bagaimana formula nya untuk menghitung jumlah gaji yang status nya L
> saja ? dengan catatan kadang-kadang ada status yang masih belum di isi,
> ini bisa dilihat dengan kosong nya kolom status.
>
> Mohon sekiranya bantuan dari rekan-rekan semuanya,
>
> Sebelum dan sesudahnya saya ucapkan terima kasih
>
> Salam,
>
> Wiwien
>
>
>
[Non-text portions of this message have been removed]
--
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia
Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED]
:: Hapus bagian yang tidak perlu (footer, dst) saat reply! ::
## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ##
$$ Iklan/promosi : www.itcenter.or.id/sponsorship $$
[@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ITCENTER/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
Re: [ITCENTER] formula di Excel
gmana kalo C = A ? soalnya kurang jelas - Original Message - From: "Yora Friano" <[EMAIL PROTECTED]> To: Sent: Saturday, November 26, 2005 6:10 PM Subject: RE: [ITCENTER] formula di Excel > saya sebenarnya jg ga tau caranya, tapi gabung aja di milis [XL-mania] di > YGroups. Banyak yang bisa jawab disana... > > -Original Message- > From: ITCENTER@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf > Of qpass > Sent: 24 Nopember 2005 14:58 > To: ITCENTER@yahoogroups.com > Subject: [ITCENTER] formula di Excel > > Sya punya masalah dengan excel begini ceritanya: > > kolom A BC > 1122 >2211 > Hasil yang diinginkan > > A BC > 1122 11 > 221122 > > gimana caranya yah selian short ini contoh gampanya aja.. > di C menggunakan function Vlook upkah ...? > -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] :: Hapus bagian yang tidak perlu (footer, dst) saat reply! :: ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ITCENTER/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [ITCENTER] formula di Excel
Lakukan vlookup di C1 sbb: =VLOOKUP(A1;$B$1:$B$5;1;0). Tanda '$' digunakan untuk mengunci range di B agar tidak bergerak saat dicopy ke C2 s/d C5. Kemudian copy ke C2 dan C5. Hasilnya: =VLOOKUP(A2;$B$1:$B$5;1;0) =VLOOKUP(A3;$B$1:$B$5;1;0) dst... Salam, Agoes - Original Message - From: "Setyo Suhartanto" <[EMAIL PROTECTED]> To: Sent: Monday, November 28, 2005 3:19 AM Subject: Re: [ITCENTER] formula di Excel Sekilas sih pake VLOOKUP, tapi trs yg mau dimunculin di C apa ya? On 11/25/05, qpass <[EMAIL PROTECTED]> wrote: > > ok real datanya spt ini > > ABC > 01010-31845 02777-00218 > 01010-5125504065-09030 > 02777-0021801010-31845 > 04065-0903001010-51255 > > maksud Sayagimana caranya untuk menemukan data di B berdasarkan isi > dari > A (misal 01010-31845) kemudian hasilnya masuk ke C dengan row yang sama. > > > - Original Message - > From: "Setyo Suhartanto" <[EMAIL PROTECTED]> > To: > Sent: Friday, November 25, 2005 8:46 AM > Subject: Re: [ITCENTER] formula di Excel > > > Iya nih, setuju ma Agoes. > Kalo cuma gitu, =A udah selesai. > > On 11/25/05, Agoes Boedi Poerwanto <[EMAIL PROTECTED]> wrote: > > > > Nah, kalau hasilnya begini banyak kemungkinannya. Secara gampang Cn=An > > :-). > > Tapi kalau ada suatu fungsi khusus untuk mendapatkannya, mungkin fungsi > > 'IF' > > bisa membantu. > > > > Salam, > > Agoes > > > > - Original Message - > > From: "qpass" <[EMAIL PROTECTED]> > > To: > > Sent: Thursday, November 24, 2005 8:57 AM > > Subject: [ITCENTER] formula di Excel > > > > > > > Sya punya masalah dengan excel begini ceritanya: > > > > > > kolom A BC > > > 1122 > > >2211 > > > Hasil yang diinginkan > > > > > > A BC > > > 1122 11 > > > 221122 > > > > > > gimana caranya yah selian short ini contoh gampanya aja.. > > > di C menggunakan function Vlook upkah ...? > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Info, > > Gabung, > > > Keluar, Mode Kirim : [EMAIL PROTECTED] :: Hapus bagian > yang > > > tidak perlu (footer, dst) saat reply! :: ## Jobs: > > > itcenter.or.id/jobs## > > > Bursa: itcenter.or.id/bursa ## > > > $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ > > > > > > [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > Få Yahoo! Mail med 6 mb lagerplads, spamfilter og virusscan. > > http://dk.mail.yahoo.com > > > > > > -- > > www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia > > Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] > > :: Hapus bagian yang tidak perlu (footer, dst) saat reply! :: > > ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## > > $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ > > > > [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > -- > www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia > Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] > :: Hapus bagian yang tidak perlu (footer, dst) saat reply! :: > ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## > $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ > > [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > -- > www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia > Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] > :: Hapus bagian yang tidak perlu (footer, dst) saat reply! :: > ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## > $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ > > [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id > > > Yahoo! Groups Links > > > > > > > [Non-text
Re: [ITCENTER] formula di Excel
ikut komen ah,. yang aku tangkep seh, lo mau nampilin data kolom A di kolom C pada baris yang sama dengan syarat data di kolom A harus ada di kolom B gitu yak ??? kalo maksudnya gitu mungkin bisa pake kombinasi formula seperti ini : 1 AB C 2 01010-3184502777-00218 =IF(COUNTIF($B$2:$B$5,B2)=1,B2,"Nihil") 3 01010-5125504065-09030 =IF(COUNTIF($B$2:$B$5,B3)=1,B3,"Nihil") 4 02777-0021801010-31845dst 5 04065-0903001010-51255dst formula countif adalah formula untuk menghitung jumlah data pada suatu range dengan kriteria yang kita tentukan. silakan dicoba semoga membantu Wassalam Abi Iqbal - Original Message - From: "Setyo Suhartanto" <[EMAIL PROTECTED]> To: Sent: Monday, November 28, 2005 9:19 AM Subject: Re: [ITCENTER] formula di Excel Sekilas sih pake VLOOKUP, tapi trs yg mau dimunculin di C apa ya? On 11/25/05, qpass <[EMAIL PROTECTED]> wrote: > > ok real datanya spt ini > > ABC > 01010-31845 02777-00218 > 01010-5125504065-09030 > 02777-0021801010-31845 > 04065-0903001010-51255 > > maksud Sayagimana caranya untuk menemukan data di B berdasarkan isi > dari > A (misal 01010-31845) kemudian hasilnya masuk ke C dengan row yang sama. > > > - Original Message - > From: "Setyo Suhartanto" <[EMAIL PROTECTED]> > To: > Sent: Friday, November 25, 2005 8:46 AM > Subject: Re: [ITCENTER] formula di Excel > > > Iya nih, setuju ma Agoes. > Kalo cuma gitu, =A udah selesai. > > On 11/25/05, Agoes Boedi Poerwanto <[EMAIL PROTECTED]> wrote: > > > > Nah, kalau hasilnya begini banyak kemungkinannya. Secara gampang Cn=An > > :-). > > Tapi kalau ada suatu fungsi khusus untuk mendapatkannya, mungkin fungsi > > 'IF' > > bisa membantu. > > > > Salam, > > Agoes > > > > - Original Message - > > From: "qpass" <[EMAIL PROTECTED]> > > To: > > Sent: Thursday, November 24, 2005 8:57 AM > > Subject: [ITCENTER] formula di Excel > > > > > > > Sya punya masalah dengan excel begini ceritanya: > > > > > > kolom A BC > > > 1122 > > >2211 > > > Hasil yang diinginkan > > > > > > A BC > > > 1122 11 > > > 221122 > > > > > > gimana caranya yah selian short ini contoh gampanya aja.. > > > di C menggunakan function Vlook upkah ...? ___ How much free photo storage do you get? Store your holiday snaps for FREE with Yahoo! Photos http://uk.photos.yahoo.com -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] :: Hapus bagian yang tidak perlu (footer, dst) saat reply! :: ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ITCENTER/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [ITCENTER] formula di Excel
Sekilas sih pake VLOOKUP, tapi trs yg mau dimunculin di C apa ya? On 11/25/05, qpass <[EMAIL PROTECTED]> wrote: > > ok real datanya spt ini > > ABC > 01010-31845 02777-00218 > 01010-5125504065-09030 > 02777-0021801010-31845 > 04065-0903001010-51255 > > maksud Sayagimana caranya untuk menemukan data di B berdasarkan isi > dari > A (misal 01010-31845) kemudian hasilnya masuk ke C dengan row yang sama. > > > - Original Message - > From: "Setyo Suhartanto" <[EMAIL PROTECTED]> > To: > Sent: Friday, November 25, 2005 8:46 AM > Subject: Re: [ITCENTER] formula di Excel > > > Iya nih, setuju ma Agoes. > Kalo cuma gitu, =A udah selesai. > > On 11/25/05, Agoes Boedi Poerwanto <[EMAIL PROTECTED]> wrote: > > > > Nah, kalau hasilnya begini banyak kemungkinannya. Secara gampang Cn=An > > :-). > > Tapi kalau ada suatu fungsi khusus untuk mendapatkannya, mungkin fungsi > > 'IF' > > bisa membantu. > > > > Salam, > > Agoes > > > > - Original Message - > > From: "qpass" <[EMAIL PROTECTED]> > > To: > > Sent: Thursday, November 24, 2005 8:57 AM > > Subject: [ITCENTER] formula di Excel > > > > > > > Sya punya masalah dengan excel begini ceritanya: > > > > > > kolom A BC > > > 1122 > > >2211 > > > Hasil yang diinginkan > > > > > > A BC > > > 1122 11 > > > 221122 > > > > > > gimana caranya yah selian short ini contoh gampanya aja.. > > > di C menggunakan function Vlook upkah ...? > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Info, > > Gabung, > > > Keluar, Mode Kirim : [EMAIL PROTECTED] :: Hapus bagian > yang > > > tidak perlu (footer, dst) saat reply! :: ## Jobs: itcenter.or.id/jobs## > > > Bursa: itcenter.or.id/bursa ## > > > $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ > > > > > > [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > Få Yahoo! Mail med 6 mb lagerplads, spamfilter og virusscan. > > http://dk.mail.yahoo.com > > > > > > -- > > www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia > > Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] > > :: Hapus bagian yang tidak perlu (footer, dst) saat reply! :: > > ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## > > $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ > > > > [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > -- > www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia > Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] > :: Hapus bagian yang tidak perlu (footer, dst) saat reply! :: > ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## > $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ > > [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > -- > www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia > Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] > :: Hapus bagian yang tidak perlu (footer, dst) saat reply! :: > ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## > $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ > > [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id > > > Yahoo! Groups Links > > > > > > > [Non-text portions of this message have been removed] -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] :: Hapus bagian yang tidak perlu (footer, dst) saat reply! :: ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ITCENTER/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [ITCENTER] formula di Excel
saya sebenarnya jg ga tau caranya, tapi gabung aja di milis [XL-mania] di YGroups. Banyak yang bisa jawab disana... -Original Message- From: ITCENTER@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of qpass Sent: 24 Nopember 2005 14:58 To: ITCENTER@yahoogroups.com Subject: [ITCENTER] formula di Excel Sya punya masalah dengan excel begini ceritanya: kolom A BC 1122 2211 Hasil yang diinginkan A BC 1122 11 221122 gimana caranya yah selian short ini contoh gampanya aja.. di C menggunakan function Vlook upkah ...? -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] :: Hapus bagian yang tidak perlu (footer, dst) saat reply! :: ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id Yahoo! Groups Links __ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] :: Hapus bagian yang tidak perlu (footer, dst) saat reply! :: ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ITCENTER/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [ITCENTER] formula di Excel
ok real datanya spt ini ABC 01010-31845 02777-00218 01010-5125504065-09030 02777-0021801010-31845 04065-0903001010-51255 maksud Sayagimana caranya untuk menemukan data di B berdasarkan isi dari A (misal 01010-31845) kemudian hasilnya masuk ke C dengan row yang sama. - Original Message - From: "Setyo Suhartanto" <[EMAIL PROTECTED]> To: Sent: Friday, November 25, 2005 8:46 AM Subject: Re: [ITCENTER] formula di Excel Iya nih, setuju ma Agoes. Kalo cuma gitu, =A udah selesai. On 11/25/05, Agoes Boedi Poerwanto <[EMAIL PROTECTED]> wrote: > > Nah, kalau hasilnya begini banyak kemungkinannya. Secara gampang Cn=An > :-). > Tapi kalau ada suatu fungsi khusus untuk mendapatkannya, mungkin fungsi > 'IF' > bisa membantu. > > Salam, > Agoes > > - Original Message - > From: "qpass" <[EMAIL PROTECTED]> > To: > Sent: Thursday, November 24, 2005 8:57 AM > Subject: [ITCENTER] formula di Excel > > > > Sya punya masalah dengan excel begini ceritanya: > > > > kolom A BC > > 1122 > >2211 > > Hasil yang diinginkan > > > > A BC > > 1122 11 > > 221122 > > > > gimana caranya yah selian short ini contoh gampanya aja.. > > di C menggunakan function Vlook upkah ...? > > > > > > > > > > > > > > > > > > > > > > -- > > www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Info, > Gabung, > > Keluar, Mode Kirim : [EMAIL PROTECTED] :: Hapus bagian yang > > tidak perlu (footer, dst) saat reply! :: ## Jobs: itcenter.or.id/jobs ## > > Bursa: itcenter.or.id/bursa ## > > $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ > > > > [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > Få Yahoo! Mail med 6 mb lagerplads, spamfilter og virusscan. > http://dk.mail.yahoo.com > > > -- > www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia > Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] > :: Hapus bagian yang tidak perlu (footer, dst) saat reply! :: > ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## > $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ > > [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id > > > Yahoo! Groups Links > > > > > > > [Non-text portions of this message have been removed] -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] :: Hapus bagian yang tidak perlu (footer, dst) saat reply! :: ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id Yahoo! Groups Links -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] :: Hapus bagian yang tidak perlu (footer, dst) saat reply! :: ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ITCENTER/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [ITCENTER] formula di Excel
ok real datanya spt ini ABC 01010-31845 02777-00218 01010-5125504065-09030 02777-0021801010-31845 04065-0903001010-51255 maksud Sayagimana caranya untuk menemukan data di B berdasarkan isi dari A (misal 01010-31845) kemudian hasilnya masuk ke C dengan row yang sama. - Original Message - From: "Setyo Suhartanto" <[EMAIL PROTECTED]> To: Sent: Friday, November 25, 2005 8:46 AM Subject: Re: [ITCENTER] formula di Excel Iya nih, setuju ma Agoes. Kalo cuma gitu, =A udah selesai. On 11/25/05, Agoes Boedi Poerwanto <[EMAIL PROTECTED]> wrote: > > Nah, kalau hasilnya begini banyak kemungkinannya. Secara gampang Cn=An > :-). > Tapi kalau ada suatu fungsi khusus untuk mendapatkannya, mungkin fungsi > 'IF' > bisa membantu. > > Salam, > Agoes > > - Original Message - > From: "qpass" <[EMAIL PROTECTED]> > To: > Sent: Thursday, November 24, 2005 8:57 AM > Subject: [ITCENTER] formula di Excel > > > > Sya punya masalah dengan excel begini ceritanya: > > > > kolom A BC > > 1122 > >2211 > > Hasil yang diinginkan > > > > A BC > > 1122 11 > > 221122 > > > > gimana caranya yah selian short ini contoh gampanya aja.. > > di C menggunakan function Vlook upkah ...? > > > > > > > > > > > > > > > > > > > > > > -- > > www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Info, > Gabung, > > Keluar, Mode Kirim : [EMAIL PROTECTED] :: Hapus bagian yang > > tidak perlu (footer, dst) saat reply! :: ## Jobs: itcenter.or.id/jobs ## > > Bursa: itcenter.or.id/bursa ## > > $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ > > > > [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > Få Yahoo! Mail med 6 mb lagerplads, spamfilter og virusscan. > http://dk.mail.yahoo.com > > > -- > www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia > Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] > :: Hapus bagian yang tidak perlu (footer, dst) saat reply! :: > ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## > $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ > > [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id > > > Yahoo! Groups Links > > > > > > > [Non-text portions of this message have been removed] -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] :: Hapus bagian yang tidak perlu (footer, dst) saat reply! :: ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id Yahoo! Groups Links -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] :: Hapus bagian yang tidak perlu (footer, dst) saat reply! :: ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ITCENTER/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [ITCENTER] formula di Excel
Ikut milistnya aja +-:: XL-mania --+ | | | Menggunakan Microsoft Excel? Mau sharing problem? atau... sharing | | tips? Join XL-mania!!! kirim e-mail kosong ke : | | [EMAIL PROTECTED] | | | +---+ Regards, Deddy Wansagitta -Original Message- From: ITCENTER@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of qpass Sent: Thursday, November 24, 2005 2:58 PM To: ITCENTER@yahoogroups.com Subject: [ITCENTER] formula di Excel Sya punya masalah dengan excel begini ceritanya: kolom A BC 1122 2211 Hasil yang diinginkan A BC 1122 11 221122 gimana caranya yah selian short ini contoh gampanya aja.. di C menggunakan function Vlook upkah ...? -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] :: Hapus bagian yang tidak perlu (footer, dst) saat reply! :: ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id Yahoo! Groups Links -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] :: Hapus bagian yang tidak perlu (footer, dst) saat reply! :: ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ITCENTER/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [ITCENTER] formula di Excel
Iya nih, setuju ma Agoes. Kalo cuma gitu, =A udah selesai. On 11/25/05, Agoes Boedi Poerwanto <[EMAIL PROTECTED]> wrote: > > Nah, kalau hasilnya begini banyak kemungkinannya. Secara gampang Cn=An > :-). > Tapi kalau ada suatu fungsi khusus untuk mendapatkannya, mungkin fungsi > 'IF' > bisa membantu. > > Salam, > Agoes > > - Original Message - > From: "qpass" <[EMAIL PROTECTED]> > To: > Sent: Thursday, November 24, 2005 8:57 AM > Subject: [ITCENTER] formula di Excel > > > > Sya punya masalah dengan excel begini ceritanya: > > > > kolom A BC > > 1122 > >2211 > > Hasil yang diinginkan > > > > A BC > > 1122 11 > > 221122 > > > > gimana caranya yah selian short ini contoh gampanya aja.. > > di C menggunakan function Vlook upkah ...? > > > > > > > > > > > > > > > > > > > > > > -- > > www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Info, > Gabung, > > Keluar, Mode Kirim : [EMAIL PROTECTED] :: Hapus bagian yang > > tidak perlu (footer, dst) saat reply! :: ## Jobs: itcenter.or.id/jobs ## > > Bursa: itcenter.or.id/bursa ## > > $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ > > > > [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > Få Yahoo! Mail med 6 mb lagerplads, spamfilter og virusscan. > http://dk.mail.yahoo.com > > > -- > www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia > Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] > :: Hapus bagian yang tidak perlu (footer, dst) saat reply! :: > ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## > $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ > > [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id > > > Yahoo! Groups Links > > > > > > > [Non-text portions of this message have been removed] -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] :: Hapus bagian yang tidak perlu (footer, dst) saat reply! :: ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ITCENTER/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [ITCENTER] formula di Excel
Nah, kalau hasilnya begini banyak kemungkinannya. Secara gampang Cn=An :-). Tapi kalau ada suatu fungsi khusus untuk mendapatkannya, mungkin fungsi 'IF' bisa membantu. Salam, Agoes - Original Message - From: "qpass" <[EMAIL PROTECTED]> To: Sent: Thursday, November 24, 2005 8:57 AM Subject: [ITCENTER] formula di Excel > Sya punya masalah dengan excel begini ceritanya: > > kolom A BC > 1122 >2211 > Hasil yang diinginkan > > A BC > 1122 11 > 221122 > > gimana caranya yah selian short ini contoh gampanya aja.. > di C menggunakan function Vlook upkah ...? > > > > > > > > > > > -- > www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Info, Gabung, > Keluar, Mode Kirim : [EMAIL PROTECTED] :: Hapus bagian yang > tidak perlu (footer, dst) saat reply! :: ## Jobs: itcenter.or.id/jobs ## > Bursa: itcenter.or.id/bursa ## > $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ > > [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id > > Yahoo! Groups Links > > > > > > Få Yahoo! Mail med 6 mb lagerplads, spamfilter og virusscan. http://dk.mail.yahoo.com -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] :: Hapus bagian yang tidak perlu (footer, dst) saat reply! :: ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ITCENTER/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
