Hot Fox

sábado, 30 de junho de 2012

Bls: ]] XL-mania [[ ambil datanya mundur satu kolom untuk setiap baris ke bawah

Pak Bambang Sumanto,

Dari beberapa postingan, silahkan dipilih yang sesuai maksud dan harapan....

Kalau saya sih biasa pakai offset, karena menurut saya, lebih mudah dimengerti

misalnya di cell j13, ketik rumus =I13*OFFSET(H$3,,-ROW(1:1)), silahkan dicopy ke bawah

dan di cell k13 ketik rumus =I13*OFFSET(G$3,,-ROW(1:1)), silahkan dicopy ke bawah

mudah2an sesuai harapan

Salam, YouSee

Dari: bambang sumanto <lenterahati2002@yahoo.com>
Kepada: "XL-mania@yahoogroups.com" <XL-mania@yahoogroups.com>
Dikirim: Rabu, 27 Juni 2012 8:48
Judul: ]] XL-mania [[ ambil datanya mundur satu kolom untuk setiap baris ke bawah

Para rekan Xl-Mania

ada data angsuran, dimana untuk ambil data pengalinya (dari data jual) itu ketika copy kebawah

otomatis ambil datanya mundur satu kolom

yang saya lakukan masih manual satu satu

jadi setiap turun satu baris, saya mengalikannya klik kolom (data jual) satu persatu

padahal datanya banyak

he he he mohon maaf saya sendiri bingung bagaimana cara menceritakannya

mudah2an lampirannya bisa lebih menjelaskan.

terimakasih atas bantuannya.

Bambang

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (8)

Recent Activity:

New Members 39

Visit Your Group

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Woooowwww... member XL-mania tembus 20,000!!!                     |
+-------------------------------------------------------------------+
| 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.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              |
+-------------------------------------------------------------------+

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

__,_._,___

Re: ]] XL-mania [[ Converter

'Alaikum salam,

Dengan fungsi bawaan excel DEC2BIN, kapasitasnya sangat terbatas

Bilangan desimal tertinggi yg dapat dikonversi menjadi bilangan Binary hanya sampai 511

512 sudah menghasilkan #NUM

Solusinya dibuatkan Fungsi Sendiri

Lihat WorkBook Lampiran

Untuk memperbesar kapasitas anda dapat mengedit VBA Code nya

~Rara

2012/6/30 Abdul <moslem_hd@yahoo.co.id>
>
> Assalamu`alaikum
> Saya masih pemula, banyak yang posting masalah convert Biner ke Decimal,

> cuma ketemu kasus. ada 1000 digit / karakter
> bilangan biner. contoh ( 110111111110100100....(nol nya sampe 996).0011),
> jika dg rumus =DEC itu hasilnya #Value,
> ada solusi ga agar 100o digit bilangan biner itu dapat di cari ke Desimal
> mohon bantuannya
> makasih

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

New Members 39

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

__,_._,___

sexta-feira, 29 de junho de 2012

Re: ]] XL-mania [[ Formula aray

Mungkin bisa pakai seperti ini pak...

Formula untuk mengHITUNG data ber-(font)-KolorItem, ( Array Formula Hasil Tunggal )

=SUM(IF(FontColorIdx(B12:K12)=1,1,0))

Formula untuk menghitung data "delay", ( Formula biasa-biasa saja )

=COUNTIF(M12:S12,"delay")

2012/6/28 NANG Agus <nangagus@gmail.com>
>
> Dear rekan-rekan Excel
> Saya mencoba untuk membuat formula array menggunakan Cell kok tidak bisa yaaaa?
> Mohon pencerahan, formula apa saja yang tidak dapat digunakan untuk array?
> Saya mencoba menyelesaikan persoalan pak Banyar Pasaribu, sudah saya pakai dummi cell

> dengan 10 column. berhasil dengan baik, tetapi saya coba dengan Array formula kok gagal terus.

> Tolong dilanjutkan yaa
>
> Regard
> NangAgus

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

New Members 45

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

__,_._,___

Re: ]] XL-mania [[ Fungsi "IF" untuk TEXT

Formula untuk mengHITUNG data ber-(font)-KolorItem

( Array Formula Hasil Tunggal )

=SUM(IF(FontColorIdx(B12:K12)=1,1,0))

Formula untk menghitung data "dalay"

( Formula abal-abal )

=COUNTIF(M12:S12,"delay")

2012/6/18 Banyar Pasaribu <BanyarP@sbm.shimano.com.sg>

Dear Para Pakar,
Formula apa yang bisa di buat untuk mendapatkan result seperti terlampir

Salam
Banyar P

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

New Members 45

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

__,_._,___

]] XL-mania [[ Converter

Assalamu`alaikum
Saya masih pemula, banyak yang posting masalah convert Biner ke Decimal, cuma ketemu kasus. ada 1000 digit / karakter
bilangan biner. contoh ( 110111111110100100....(nol nya sampe 996).0011)
, jika dg rumus =DEC itu hasilnya #Value,
ada solusi ga agar 100o digit bilangan biner itu dapat di cari ke Desimal
mohon bantuannya
makasih

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

New Members 45

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

__,_._,___

Re: ]] XL-mania [[ Keanehan Excel

Dear Hasbullah,

File yang anda kirimkan bukan hal yang aneh. perbedaan terdapat pada karakter ke 11, (dilihat mata manusia karakter tersebut sama yaitu spasi kosong, namun Excel tahu bahwa kedua karakter tersebut adalah berbeda) yang satu karakter no 32 yang lainnya karakter no 160.
coba jika kedua karakter tersebut disamakan (sama-sama 32 atau sama-sama 60) maka jawabnya akan sama.

Lihat attachment

salam
NangAgus

On Fri, Jun 29, 2012 at 8:57 AM, Has Bullah <has.bullah@sanmina-sci.com> wrote:

Hallo pakar excel

saya menemukan kejanggalan untuk cell value seperti yang ada di lampiran.
untuk 2 cell value yang sama tapi ternyata dianggap berbeda (setelah ditelusuri dengan formula)
mohon dibantu apa yang meyebabkan perbedaan tersebut
terima kasih atas bantuannya

Hasbullah

Reply to sender | Reply to group | Reply via web post | Start a New Topic
Messages in this topic (1)

Recent Activity:

New Members 45

Visit Your Group

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Woooowwww... member XL-mania tembus 20,000!!!                     |
+-------------------------------------------------------------------+
| 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.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              |
+-------------------------------------------------------------------+

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (4)

Recent Activity:

New Members 47

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

__,_._,___

Re: ]] XL-mania [[ Keanehan Excel

Perbedaannya terletak di spasi antara "HEATSINK," dengan "ESB".

Spasi di cell C5 bukan spasi biasa. Tetapi spasi yang bukan untuk pemisah kata. Kemungkinan spasi tersebut bukan dgn mengetik space bar di keyboard, tetapi copy dari bahasa program yang berbeda, atau insert simbol.

Regards,

On Fri, Jun 29, 2012 at 8:57 AM, Has Bullah <has.bullah@sanmina-sci.com> wrote:

Hallo pakar excel

saya menemukan kejanggalan untuk cell value seperti yang ada di lampiran.
untuk 2 cell value yang sama tapi ternyata dianggap berbeda (setelah ditelusuri dengan formula)
mohon dibantu apa yang meyebabkan perbedaan tersebut
terima kasih atas bantuannya

Hasbullah

CONFIDENTIALITY  This e-mail message and any attachments thereto, is intended only for use by the addressee(s) named herein and may contain legally privileged and/or confidential information. If you are not the intended recipient of this e-mail message, you are hereby notified that any dissemination, distribution or copying of this e-mail message, and any attachments thereto, is strictly prohibited.  If you have received this e-mail message in error, please immediately notify the sender and permanently delete the original and any copies of this email and any prints thereof.  ABSENT AN EXPRESS STATEMENT TO THE CONTRARY HEREINABOVE, THIS E-MAIL IS NOT INTENDED AS A SUBSTITUTE FOR A WRITING.  Notwithstanding the Uniform Electronic Transactions Act or the applicability of any other law of similar substance and effect, absent an express statement to the contrary hereinabove, this e-mail message its contents, and any attachments hereto are not intended to represent an offer or acceptance to enter into a contract and are not otherwise intended to bind the sender, Sanmina-SCI Corporation (or any of its subsidiaries), or any other person or entity.

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (3)

Recent Activity:

New Members 47

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

__,_._,___

Re: ]] XL-mania [[ Keanehan Excel

Hal tersebut disebabkan karena adanya karakter spasi berkode 160.
Coba cek dengan :
=Code( Mid( teksnya , karakter ke , 1 ) )
Ganti teksnya dengan rujukan cell si data,
Ganti karakter ke dengan angka posisi karakter yang tampak sebagai spasi.

Wassalam,
Kid.

On Fri, Jun 29, 2012 at 8:57 AM, Has Bullah <has.bullah@sanmina-sci.com> wrote:

CONFIDENTIALITY  This e-mail message and any attachments thereto, is intended only for use by the addressee(s) named herein and may contain legally privileged and/or confidential information. If you are not the intended recipient of this e-mail message, you are hereby notified that any dissemination, distribution or copying of this e-mail message, and any attachments thereto, is strictly prohibited.  If you have received this e-mail message in error, please immediately notify the sender and permanently delete the original and any copies of this email and any prints thereof.  ABSENT AN EXPRESS STATEMENT TO THE CONTRARY HEREINABOVE, THIS E-MAIL IS NOT INTENDED AS A SUBSTITUTE FOR A WRITING.  Notwithstanding the Uniform Electronic Transactions Act or the applicability of any other law of similar substance and effect, absent an express statement to the contrary hereinabove, this e-mail message its contents, and any attachments hereto are not intended to represent an offer or acceptance to enter into a contract and are not otherwise intended to bind the sender, Sanmina-SCI Corporation (or any of its subsidiaries), or any other person or entity.

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

New Members 47

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

__,_._,___

Bls: ]] XL-mania [[ cara menggunakan rumus IF

Mungkin formulanya secara sederhana adalah seperti ini semoga bermanfaat

Dari: Sudiro Husodo <diron0@yahoo.co.id>
Kepada: XL-mania@yahoogroups.com
Dikirim: Kamis, 28 Juni 2012 11:33
Judul: ]] XL-mania [[ cara menggunakan rumus IF

Selamat Siang

dear para masters

minta tolong bagaimana menggunakan rumus if untuk mencari status kelulusan.

terima kasih

salam,

diro.

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

New Members 45

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

__,_._,___

quinta-feira, 28 de junho de 2012

]] XL-mania [[ Keanehan Excel

CONFIDENTIALITY  This e-mail message and any attachments thereto, is intended only for use by the addressee(s) named herein and may contain legally privileged and/or confidential information. If you are not the intended recipient of this e-mail message, you are hereby notified that any dissemination, distribution or copying of this e-mail message, and any attachments thereto, is strictly prohibited.  If you have received this e-mail message in error, please immediately notify the sender and permanently delete the original and any copies of this email and any prints thereof.  ABSENT AN EXPRESS STATEMENT TO THE CONTRARY HEREINABOVE, THIS E-MAIL IS NOT INTENDED AS A SUBSTITUTE FOR A WRITING.  Notwithstanding the Uniform Electronic Transactions Act or the applicability of any other law of similar substance and effect, absent an express statement to the contrary hereinabove, this e-mail message its contents, and any attachments hereto are not intended to represent an offer or acceptance to enter into a contract and are not otherwise intended to bind the sender, Sanmina-SCI Corporation (or any of its subsidiaries), or any other person or entity.

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

New Members 45

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

__,_._,___

Re: ]] XL-mania [[ cara menggunakan rumus IF

Yth Pak diro

Mohon maaf mungkin saya dapat dibilang orang yang ngeyelan. file yang anda hadiahkan kepada xl mania bukan data yang dibutuhkan, tetapi hanya berisi syarat yang dibutuhkan. Jadi file tersebut masih sama dengan file pdf yang kemarin. sebaiknya file berisi:

Nama	Nilai1	Nilai2	Nilai3	Nilai4	Nilai5		IPS	Kelulusan
Agus	A	A	D	E	C		3,5

Apakah maksudnya semua member harus membuat nilainya dulu? kami kan tidak tahu ada berapa nilai semuannya

Kami bukannya malas membuat file tersebut, tetapi kami juga punya pekerjaan lain yang harus diselesaikan. Saya percaya semua member pekerjaannya bukan menjadi Penanggap (penjawab) Mailing list ini
Mohon maaf bila kata-kata saya dirasa kasar, mohon untuk diedit oleh moderator, terima kasih

2012/6/28 Sudiro Husodo <diron0@yahoo.co.id>

Selamat Siang

dear para masters

minta tolong bagaimana menggunakan rumus if untuk mencari status kelulusan.

terima kasih

salam,

diro.

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (3)

Recent Activity:

New Members 45

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

__,_._,___

sábado, 30 de junho de 2012

sexta-feira, 29 de junho de 2012

quinta-feira, 28 de junho de 2012

Arquivo do blog