[ITCENTER] formula di excel
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] -- 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
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)
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
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)
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
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
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: ITCENTER@yahoogroups.com
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 (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/
[ITCENTER] Formula di Excel
Rekans, minta dolong dong. saya punya permasalahan di excel nih, ceritanya gini : ada 2 kolom, yaitu gaji dan status, contoh : Gajistatus 20K 25K 225000L 30K 40L 225000L 275000K 30 245000 30K 325000L 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 -- 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: ITCENTER@yahoogroups.com 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
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: ITCENTER@yahoogroups.com 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: ITCENTER@yahoogroups.com 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: ITCENTER@yahoogroups.com 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: ITCENTER@yahoogroups.com 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
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[2]: [ITCENTER] formula di Excel
Hello qpass, Friday, November 25, 2005, 4:19:33 PM, you wrote: Apa ini yang anda maksud kan 1 AB C 2 01010-3184502777-00218 =Vlookup(A2,data,1,false) 3 01010-5125504065-09030 =Vlookup(A3,data,1,false) 4 02777-0021801010-31845 =Vlookup(A4,data,1,false) 5 04065-0903001010-51255 =Vlookup(A5,data,1,false) Sebelumnya B2..B5 kasih range name data, atau sesuai selera 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. -- Best regards, Fansul mailto:[EMAIL PROTECTED] -- 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: ITCENTER@yahoogroups.com 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: ITCENTER@yahoogroups.com 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
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: ITCENTER@yahoogroups.com 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: ITCENTER@yahoogroups.com 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: ITCENTER@yahoogroups.com 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 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/
[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
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: ITCENTER@yahoogroups.com 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/
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: ITCENTER@yahoogroups.com 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
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/
