Selasa, 30 Juli 2019

[belajar-excel] Digest Number 4808

11 Messages

Digest #4808

Messages

Mon Jul 29, 2019 10:44 pm (PDT) . Posted by:

"Zainul Ulum" zainul_ulum

Wa'alaikum salaam,
File terlampir menggunakan protected sheet tanpa menggunakan macro.
Apakah sudah sesuai yang diinginkan?

Wassalam
-zainul

Sent from Mail for Windows 10

From: HAIRUL ALAM ha_mj76@yahoo.co.id [belajar-excel]
Sent: Tuesday, July 30, 2019 7:47 AM
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] menampilkan hasil tanpa formula di excel dengan script macro

 
Salam
Para Master

mohon pencerahahannya dengan code script macro menampilkan hasil formula tanpa menampilkan rumus di cell excel, seperti file terlampir

Terimakasih

Assalamualaikum

Hairul Alam

Mon Jul 29, 2019 11:56 pm (PDT) . Posted by:

"Stephen Saputro"

Kalau hanya sekedar look up, terlalu ribet kalau harus memakai VBA, itu
menurut saya hehe.
Kalau kasus seperti ini masih bisa optimalkan pivot, terus tinggal di
tambahin slicer untuk mempercantik.

1. blok semua table, tekan ctrl + T

[image: image.png]

2. klik my table has header

[image: image.png]

3. tetap di blok table nya, terus pilih insert > pivot table

[image: image.png]

5. Selanjut nya tinggal ikut conth nya, Untuk Slicer, ada di tab Analyse >
Insert Slicer > klik "No"
[image: image.png]

6. Langkah selanjutnya tinggal inpu t data dan refresh data

On Tue, Jul 30, 2019 at 7:47 AM HAIRUL ALAM ha_mj76@yahoo.co.id
[belajar-excel] <belajar-excel@yahoogroups.com> wrote:

>
>
> Salam
> Para Master
>
> mohon pencerahahannya dengan code script macro menampilkan hasil formula
> tanpa menampilkan rumus di cell excel, seperti file terlampir
>
> Terimakasih
>
> Assalamualaikum
>
> Hairul Alam
>
>
>

Tue Jul 30, 2019 12:03 am (PDT) . Posted by:

"hendrik karnadi" hendrikkarnadi

Coba ganti codenya spt ini :Sheets("b").Range("c4").Value2 = Evaluate("=VLOOKUP(B4,a!B4:D6,2,FALSE)")

Salam,HK

Pada Selasa, 30 Juli 2019 07.47.34 WIB, HAIRUL ALAM ha_mj76@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

 

SalamPara Master
mohon pencerahahannya dengan code script macro menampilkan hasil formula tanpa menampilkan rumus di cell excel, seperti file terlampir

Terimakasih
Assalamualaikum
Hairul Alam

Tue Jul 30, 2019 1:45 am (PDT) . Posted by:

"HAIRUL ALAM"

Terimakasih
Maaf yang saya maksud untuk hasilnya tidak muncul formula tapi hasil dari vlookup nya saja seperti yang terlampir sebelumnya dan itu cuma 1 contoh dan jika banyak akan tetap hasil saja
Terimakasih
Pada Selasa, 30 Juli 2019 12.44.47 WIB, Zainul Ulum zainul_ulum@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

 

Wa'alaikum salaam,

File terlampir menggunakan protected sheet tanpa menggunakan macro.

Apakah sudah sesuai yang diinginkan?

 

Wassalam

-zainul

 

 

Sent from Mail for Windows 10

 

From: HAIRUL ALAM ha_mj76@yahoo.co.id [belajar-excel]
Sent: Tuesday, July 30, 2019 7:47 AM
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] menampilkan hasil tanpa formula di excel dengan script macro

 

 

Salam

Para Master

 

mohon pencerahahannya dengan code script macro menampilkan hasil formula tanpa menampilkan rumus di cell excel, seperti file terlampir

 

Terimakasih

 

Assalamualaikum

 

Hairul Alam

 
#yiv0658632402 #yiv0658632402 -- #yiv0658632402ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0658632402 #yiv0658632402ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0658632402 #yiv0658632402ygrp-mkp #yiv0658632402hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0658632402 #yiv0658632402ygrp-mkp #yiv0658632402ads {margin-bottom:10px;}#yiv0658632402 #yiv0658632402ygrp-mkp .yiv0658632402ad {padding:0 0;}#yiv0658632402 #yiv0658632402ygrp-mkp .yiv0658632402ad p {margin:0;}#yiv0658632402 #yiv0658632402ygrp-mkp .yiv0658632402ad a {color:#0000ff;text-decoration:none;}#yiv0658632402 #yiv0658632402ygrp-sponsor #yiv0658632402ygrp-lc {font-family:Arial;}#yiv0658632402 #yiv0658632402ygrp-sponsor #yiv0658632402ygrp-lc #yiv0658632402hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0658632402 #yiv0658632402ygrp-sponsor #yiv0658632402ygrp-lc .yiv0658632402ad {margin-bottom:10px;padding:0 0;}#yiv0658632402 #yiv0658632402actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0658632402 #yiv0658632402activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0658632402 #yiv0658632402activity span {font-weight:700;}#yiv0658632402 #yiv0658632402activity span:first-child {text-transform:uppercase;}#yiv0658632402 #yiv0658632402activity span a {color:#5085b6;text-decoration:none;}#yiv0658632402 #yiv0658632402activity span span {color:#ff7900;}#yiv0658632402 #yiv0658632402activity span .yiv0658632402underline {text-decoration:underline;}#yiv0658632402 .yiv0658632402attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0658632402 .yiv0658632402attach div a {text-decoration:none;}#yiv0658632402 .yiv0658632402attach img {border:none;padding-right:5px;}#yiv0658632402 .yiv0658632402attach label {display:block;margin-bottom:5px;}#yiv0658632402 .yiv0658632402attach label a {text-decoration:none;}#yiv0658632402 blockquote {margin:0 0 0 4px;}#yiv0658632402 .yiv0658632402bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0658632402 .yiv0658632402bold a {text-decoration:none;}#yiv0658632402 dd.yiv0658632402last p a {font-family:Verdana;font-weight:700;}#yiv0658632402 dd.yiv0658632402last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0658632402 dd.yiv0658632402last p span..yiv0658632402yshortcuts {margin-right:0;}#yiv0658632402 div.yiv0658632402attach-table div div a {text-decoration:none;}#yiv0658632402 div.yiv0658632402attach-table {width:400px;}#yiv0658632402 div.yiv0658632402file-title a, #yiv0658632402 div.yiv0658632402file-title a:active, #yiv0658632402 div.yiv0658632402file-title a:hover, #yiv0658632402 div.yiv0658632402file-title a:visited {text-decoration:none;}#yiv0658632402 div.yiv0658632402photo-title a, #yiv0658632402 div.yiv0658632402photo-title a:active, #yiv0658632402 div..yiv0658632402photo-title a:hover, #yiv0658632402 div.yiv0658632402photo-title a:visited {text-decoration:none;}#yiv0658632402 div#yiv0658632402ygrp-mlmsg #yiv0658632402ygrp-msg p a span.yiv0658632402yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0658632402 .yiv0658632402green {color:#628c2a;}#yiv0658632402 .yiv0658632402MsoNormal {margin:0 0 0 0;}#yiv0658632402 o {font-size:0;}#yiv0658632402 #yiv0658632402photos div {float:left;width:72px;}#yiv0658632402 #yiv0658632402photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv0658632402 #yiv0658632402photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0658632402 #yiv0658632402reco-category {font-size:77%;}#yiv0658632402 #yiv0658632402reco-desc {font-size:77%;}#yiv0658632402 .yiv0658632402replbq {margin:4px;}#yiv0658632402 #yiv0658632402ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0658632402 #yiv0658632402ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0658632402 #yiv0658632402ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0658632402 #yiv0658632402ygrp-mlmsg select, #yiv0658632402 input, #yiv0658632402 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0658632402 #yiv0658632402ygrp-mlmsg pre, #yiv0658632402 code {font:115% monospace;}#yiv0658632402 #yiv0658632402ygrp-mlmsg * {line-height:1.22em;}#yiv0658632402 #yiv0658632402ygrp-mlmsg #yiv0658632402logo {padding-bottom:10px;}#yiv0658632402 #yiv0658632402ygrp-msg p a {font-family:Verdana;}#yiv0658632402 #yiv0658632402ygrp-msg p#yiv0658632402attach-count span {color:#1E66AE;font-weight:700;}#yiv0658632402 #yiv0658632402ygrp-reco #yiv0658632402reco-head {color:#ff7900;font-weight:700;}#yiv0658632402 #yiv0658632402ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0658632402 #yiv0658632402ygrp-sponsor #yiv0658632402ov li a {font-size:130%;text-decoration:none;}#yiv0658632402 #yiv0658632402ygrp-sponsor #yiv0658632402ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0658632402 #yiv0658632402ygrp-sponsor #yiv0658632402ov ul {margin:0;padding:0 0 0 8px;}#yiv0658632402 #yiv0658632402ygrp-text {font-family:Georgia;}#yiv0658632402 #yiv0658632402ygrp-text p {margin:0 0 1em 0;}#yiv0658632402 #yiv0658632402ygrp-text tt {font-size:120%;}#yiv0658632402 #yiv0658632402ygrp-vital ul li:last-child {border-right:none !important;}#yiv0658632402

Tue Jul 30, 2019 2:13 am (PDT) . Posted by:

zainul_ulum

Kalo pakai macro, bisa menggunakan code di bawah:


Sub v()
Const RUMUS_C4 As String = "=VLOOKUP(B4,a!$B$4:$D$6,2,FALSE)"
Const RUMUS_D4 As String = "=VLOOKUP(B4,a!$B$4:$D$6,3,FALSE)"
Const KOLOM_ISIAN As String = "B", KOLOM_TANGGAL As String = "C", KOLOM_JUMLAH As String = "D"
Const barisAwal As Long = 4
Const barisMax As Long = 10000
Const shtTarget As String = "b"


With Worksheets(shtTarget)
'mencari baris input terakhir
Dim n As Long
n = .Range(KOLOM_ISIAN & barisMax).End(xlUp).Row
'tentukan range tanggal (kolom c) dan range jumlah (kolom d)
Dim rgTanggal As Range, rgJumlah As Range
Set rgTanggal = .Range(KOLOM_TANGGAL & barisAwal & ":" & KOLOM_TANGGAL & n)
Set rgJumlah = .Range(KOLOM_JUMLAH & barisAwal & ":" & KOLOM_JUMLAH & n)
'mengisi formula
rgTanggal.Formula = RUMUS_C4
rgJumlah.Formula = RUMUS_D4
'rubah menjadi value
rgTanggal.Value = rgTanggal.Value
rgJumlah.Value = rgJumlah.Value
End With


End Sub


Tue Jul 30, 2019 5:42 am (PDT) . Posted by:

"HAIRUL ALAM"

Terimakasih Ilmunya Master

Pada Selasa, 30 Juli 2019 16.14.14 WIB, zainul_ulum@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

 

Kalo pakai macro, bisa menggunakan code di bawah:
Sub v()    Const RUMUS_C4 As String = "=VLOOKUP(B4,a!$B$4:$D$6,2,FALSE)"    Const RUMUS_D4 As String = "=VLOOKUP(B4,a!$B$4:$D$6,3,FALSE)"    Const KOLOM_ISIAN As String = "B", KOLOM_TANGGAL As String = "C", KOLOM_JUMLAH As String = "D"    Const barisAwal As Long = 4    Const barisMax As Long = 10000    Const shtTarget As String = "b"            With Worksheets(shtTarget)    'mencari baris input terakhir        Dim n As Long        n = .Range(KOLOM_ISIAN & barisMax).End(xlUp).Row    'tentukan range tanggal (kolom c) dan range jumlah (kolom d)        Dim rgTanggal As Range, rgJumlah As Range        Set rgTanggal = .Range(KOLOM_TANGGAL & barisAwal & ":" & KOLOM_TANGGAL & n)        Set rgJumlah = .Range(KOLOM_JUMLAH & barisAwal & ":" & KOLOM_JUMLAH & n)    'mengisi formula        rgTanggal.Formula = RUMUS_C4        rgJumlah.Formula = RUMUS_D4    'rubah menjadi value        rgTanggal.Value = rgTanggal.Value        rgJumlah.Value = rgJumlah.Value    End With        End Sub
#yiv5631128258 #yiv5631128258 -- #yiv5631128258ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5631128258 #yiv5631128258ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5631128258 #yiv5631128258ygrp-mkp #yiv5631128258hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5631128258 #yiv5631128258ygrp-mkp #yiv5631128258ads {margin-bottom:10px;}#yiv5631128258 #yiv5631128258ygrp-mkp .yiv5631128258ad {padding:0 0;}#yiv5631128258 #yiv5631128258ygrp-mkp .yiv5631128258ad p {margin:0;}#yiv5631128258 #yiv5631128258ygrp-mkp .yiv5631128258ad a {color:#0000ff;text-decoration:none;}#yiv5631128258 #yiv5631128258ygrp-sponsor #yiv5631128258ygrp-lc {font-family:Arial;}#yiv5631128258 #yiv5631128258ygrp-sponsor #yiv5631128258ygrp-lc #yiv5631128258hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5631128258 #yiv5631128258ygrp-sponsor #yiv5631128258ygrp-lc .yiv5631128258ad {margin-bottom:10px;padding:0 0;}#yiv5631128258 #yiv5631128258actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5631128258 #yiv5631128258activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5631128258 #yiv5631128258activity span {font-weight:700;}#yiv5631128258 #yiv5631128258activity span:first-child {text-transform:uppercase;}#yiv5631128258 #yiv5631128258activity span a {color:#5085b6;text-decoration:none;}#yiv5631128258 #yiv5631128258activity span span {color:#ff7900;}#yiv5631128258 #yiv5631128258activity span .yiv5631128258underline {text-decoration:underline;}#yiv5631128258 .yiv5631128258attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5631128258 .yiv5631128258attach div a {text-decoration:none;}#yiv5631128258 .yiv5631128258attach img {border:none;padding-right:5px;}#yiv5631128258 .yiv5631128258attach label {display:block;margin-bottom:5px;}#yiv5631128258 .yiv5631128258attach label a {text-decoration:none;}#yiv5631128258 blockquote {margin:0 0 0 4px;}#yiv5631128258 .yiv5631128258bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5631128258 .yiv5631128258bold a {text-decoration:none;}#yiv5631128258 dd.yiv5631128258last p a {font-family:Verdana;font-weight:700;}#yiv5631128258 dd.yiv5631128258last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5631128258 dd.yiv5631128258last p span.yiv5631128258yshortcuts {margin-right:0;}#yiv5631128258 div.yiv5631128258attach-table div div a {text-decoration:none;}#yiv5631128258 div.yiv5631128258attach-table {width:400px;}#yiv5631128258 div.yiv5631128258file-title a, #yiv5631128258 div.yiv5631128258file-title a:active, #yiv5631128258 div.yiv5631128258file-title a:hover, #yiv5631128258 div.yiv5631128258file-title a:visited {text-decoration:none;}#yiv5631128258 div.yiv5631128258photo-title a, #yiv5631128258 div.yiv5631128258photo-title a:active, #yiv5631128258 div.yiv5631128258photo-title a:hover, #yiv5631128258 div.yiv5631128258photo-title a:visited {text-decoration:none;}#yiv5631128258 div#yiv5631128258ygrp-mlmsg #yiv5631128258ygrp-msg p a span.yiv5631128258yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5631128258 .yiv5631128258green {color:#628c2a;}#yiv5631128258 .yiv5631128258MsoNormal {margin:0 0 0 0;}#yiv5631128258 o {font-size:0;}#yiv5631128258 #yiv5631128258photos div {float:left;width:72px;}#yiv5631128258 #yiv5631128258photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv5631128258 #yiv5631128258photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5631128258 #yiv5631128258reco-category {font-size:77%;}#yiv5631128258 #yiv5631128258reco-desc {font-size:77%;}#yiv5631128258 .yiv5631128258replbq {margin:4px;}#yiv5631128258 #yiv5631128258ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5631128258 #yiv5631128258ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5631128258 #yiv5631128258ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5631128258 #yiv5631128258ygrp-mlmsg select, #yiv5631128258 input, #yiv5631128258 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5631128258 #yiv5631128258ygrp-mlmsg pre, #yiv5631128258 code {font:115% monospace;}#yiv5631128258 #yiv5631128258ygrp-mlmsg * {line-height:1..22em;}#yiv5631128258 #yiv5631128258ygrp-mlmsg #yiv5631128258logo {padding-bottom:10px;}#yiv5631128258 #yiv5631128258ygrp-msg p a {font-family:Verdana;}#yiv5631128258 #yiv5631128258ygrp-msg p#yiv5631128258attach-count span {color:#1E66AE;font-weight:700;}#yiv5631128258 #yiv5631128258ygrp-reco #yiv5631128258reco-head {color:#ff7900;font-weight:700;}#yiv5631128258 #yiv5631128258ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5631128258 #yiv5631128258ygrp-sponsor #yiv5631128258ov li a {font-size:130%;text-decoration:none;}#yiv5631128258 #yiv5631128258ygrp-sponsor #yiv5631128258ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5631128258 #yiv5631128258ygrp-sponsor #yiv5631128258ov ul {margin:0;padding:0 0 0 8px;}#yiv5631128258 #yiv5631128258ygrp-text {font-family:Georgia;}#yiv5631128258 #yiv5631128258ygrp-text p {margin:0 0 1em 0;}#yiv5631128258 #yiv5631128258ygrp-text tt {font-size:120%;}#yiv5631128258 #yiv5631128258ygrp-vital ul li:last-child {border-right:none !important;}#yiv5631128258

Mon Jul 29, 2019 11:56 pm (PDT) . Posted by:

"imam cahyo yuwono"

Terima kasih sekali atas bantuannya... namun ada yang menurut saya masih kurang contoh Rp. 131.000,00 terbilangnya seratus tiga puluh seribu Rupiah, menurut saya terbilangnya Seratus Tiga Puluh satu Ribu Rupiah.... mohon masukannya..

On Thursday, July 25, 2019, 11:52:52 AM GMT+7, Zainul Ulum zainul_ulum@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> wrote:

 

Mas Imam,

Sudah aku tulis di https://cadex.co/2017/10/15/xls-pmg-08-fungsi-terbilang-di-excel-tanpa-macro-versi-mega-formula-rev-03/

Untuk penjelasannya.

Terimakasih,

-zainul

 

 

Sent from Mail for Windows 10

 

From: imam cahyo yuwono chyywn@yahoo.com [belajar-excel]
Sent: Thursday, July 25, 2019 10:12 AM
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] Mega Formula terbilang (terbilang tanpa macro)

 

 

Dear para expert mohon bantuan penjelasan tentang formula terbilang dibawah ini

mohon pencerahan fungsi formula dan perbaikan pada formula yang ada

 

Terima kasih 

 
#yiv3817558797 #yiv3817558797 -- #yiv3817558797ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3817558797 #yiv3817558797ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3817558797 #yiv3817558797ygrp-mkp #yiv3817558797hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3817558797 #yiv3817558797ygrp-mkp #yiv3817558797ads {margin-bottom:10px;}#yiv3817558797 #yiv3817558797ygrp-mkp .yiv3817558797ad {padding:0 0;}#yiv3817558797 #yiv3817558797ygrp-mkp .yiv3817558797ad p {margin:0;}#yiv3817558797 #yiv3817558797ygrp-mkp .yiv3817558797ad a {color:#0000ff;text-decoration:none;}#yiv3817558797 #yiv3817558797ygrp-sponsor #yiv3817558797ygrp-lc {font-family:Arial;}#yiv3817558797 #yiv3817558797ygrp-sponsor #yiv3817558797ygrp-lc #yiv3817558797hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3817558797 #yiv3817558797ygrp-sponsor #yiv3817558797ygrp-lc .yiv3817558797ad {margin-bottom:10px;padding:0 0;}#yiv3817558797 #yiv3817558797actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3817558797 #yiv3817558797activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3817558797 #yiv3817558797activity span {font-weight:700;}#yiv3817558797 #yiv3817558797activity span:first-child {text-transform:uppercase;}#yiv3817558797 #yiv3817558797activity span a {color:#5085b6;text-decoration:none;}#yiv3817558797 #yiv3817558797activity span span {color:#ff7900;}#yiv3817558797 #yiv3817558797activity span .yiv3817558797underline {text-decoration:underline;}#yiv3817558797 .yiv3817558797attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3817558797 .yiv3817558797attach div a {text-decoration:none;}#yiv3817558797 .yiv3817558797attach img {border:none;padding-right:5px;}#yiv3817558797 .yiv3817558797attach label {display:block;margin-bottom:5px;}#yiv3817558797 .yiv3817558797attach label a {text-decoration:none;}#yiv3817558797 blockquote {margin:0 0 0 4px;}#yiv3817558797 .yiv3817558797bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3817558797 .yiv3817558797bold a {text-decoration:none;}#yiv3817558797 dd.yiv3817558797last p a {font-family:Verdana;font-weight:700;}#yiv3817558797 dd.yiv3817558797last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3817558797 dd.yiv3817558797last p span.yiv3817558797yshortcuts {margin-right:0;}#yiv3817558797 div.yiv3817558797attach-table div div a {text-decoration:none;}#yiv3817558797 div.yiv3817558797attach-table {width:400px;}#yiv3817558797 div.yiv3817558797file-title a, #yiv3817558797 div.yiv3817558797file-title a:active, #yiv3817558797 div.yiv3817558797file-title a:hover, #yiv3817558797 div.yiv3817558797file-title a:visited {text-decoration:none;}#yiv3817558797 div.yiv3817558797photo-title a, #yiv3817558797 div.yiv3817558797photo-title a:active, #yiv3817558797 div.yiv3817558797photo-title a:hover, #yiv3817558797 div.yiv3817558797photo-title a:visited {text-decoration:none;}#yiv3817558797 div#yiv3817558797ygrp-mlmsg #yiv3817558797ygrp-msg p a span.yiv3817558797yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3817558797 .yiv3817558797green {color:#628c2a;}#yiv3817558797 .yiv3817558797MsoNormal {margin:0 0 0 0;}#yiv3817558797 o {font-size:0;}#yiv3817558797 #yiv3817558797photos div {float:left;width:72px;}#yiv3817558797 #yiv3817558797photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv3817558797 #yiv3817558797photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3817558797 #yiv3817558797reco-category {font-size:77%;}#yiv3817558797 #yiv3817558797reco-desc {font-size:77%;}#yiv3817558797 .yiv3817558797replbq {margin:4px;}#yiv3817558797 #yiv3817558797ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3817558797 #yiv3817558797ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3817558797 #yiv3817558797ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3817558797 #yiv3817558797ygrp-mlmsg select, #yiv3817558797 input, #yiv3817558797 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3817558797 #yiv3817558797ygrp-mlmsg pre, #yiv3817558797 code {font:115% monospace;}#yiv3817558797 #yiv3817558797ygrp-mlmsg * {line-height:1..22em;}#yiv3817558797 #yiv3817558797ygrp-mlmsg #yiv3817558797logo {padding-bottom:10px;}#yiv3817558797 #yiv3817558797ygrp-msg p a {font-family:Verdana;}#yiv3817558797 #yiv3817558797ygrp-msg p#yiv3817558797attach-count span {color:#1E66AE;font-weight:700;}#yiv3817558797 #yiv3817558797ygrp-reco #yiv3817558797reco-head {color:#ff7900;font-weight:700;}#yiv3817558797 #yiv3817558797ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3817558797 #yiv3817558797ygrp-sponsor #yiv3817558797ov li a {font-size:130%;text-decoration:none;}#yiv3817558797 #yiv3817558797ygrp-sponsor #yiv3817558797ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3817558797 #yiv3817558797ygrp-sponsor #yiv3817558797ov ul {margin:0;padding:0 0 0 8px;}#yiv3817558797 #yiv3817558797ygrp-text {font-family:Georgia;}#yiv3817558797 #yiv3817558797ygrp-text p {margin:0 0 1em 0;}#yiv3817558797 #yiv3817558797ygrp-text tt {font-size:120%;}#yiv3817558797 #yiv3817558797ygrp-vital ul li:last-child {border-right:none !important;}#yiv3817558797

Tue Jul 30, 2019 1:51 am (PDT) . Posted by:

"Zainul Ulum" zainul_ulum

Terimakasih koreksinya Mas Imam,
Akan saya koreksi formulanya.

Wassalam,
-zainul

Sent from Mail for Windows 10

From: imam cahyo yuwono chyywn@yahoo.com [belajar-excel]
Sent: Tuesday, July 30, 2019 1:56 PM
To: belajar-excel@yahoogroups.com
Subject: Re: [belajar-excel] Mega Formula terbilang (terbilang tanpa macro)

 
Terima kasih sekali atas bantuannya... namun ada yang menurut saya masih kurang contoh Rp. 131.000,00 terbilangnya seratus tiga puluh seribu Rupiah, menurut saya terbilangnya Seratus Tiga Puluh satu Ribu Rupiah... 
mohon masukannya..

On Thursday, July 25, 2019, 11:52:52 AM GMT+7, Zainul Ulum zainul_ulum@yahoo..com [belajar-excel] <belajar-excel@yahoogroups.com> wrote:

 
Mas Imam,
Sudah aku tulis di https://cadex.co/2017/10/15/xls-pmg-08-fungsi-terbilang-di-excel-tanpa-macro-versi-mega-formula-rev-03/
Untuk penjelasannya.
Terimakasih,
-zainul
 
 
Sent from Mail for Windows 10
 
From: imam cahyo yuwono chyywn@yahoo.com [belajar-excel]
Sent: Thursday, July 25, 2019 10:12 AM
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] Mega Formula terbilang (terbilang tanpa macro)
 
 
Dear para expert mohon bantuan penjelasan tentang formula terbilang dibawah ini
mohon pencerahan fungsi formula dan perbaikan pada formula yang ada
 
Terima kasih 
 

Tue Jul 30, 2019 5:42 am (PDT) . Posted by:

"imam cahyo yuwono"

maaf ada tambahan Mas Zainul... angka 1000 (Seribu) (satu Ribu) terbilang nya menjadi 1 (satu)terima kasih
On Tuesday, July 30, 2019, 03:52:21 PM GMT+7, Zainul Ulum zainul_ulum@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> wrote:

 

Terimakasih koreksinya Mas Imam,

Akan saya koreksi formulanya.

 

Wassalam,

-zainul

 

Sent from Mail for Windows 10

 

From: imam cahyo yuwono chyywn@yahoo.com [belajar-excel]
Sent: Tuesday, July 30, 2019 1:56 PM
To: belajar-excel@yahoogroups.com
Subject: Re: [belajar-excel] Mega Formula terbilang (terbilang tanpa macro)

 

 

Terima kasih sekali atas bantuannya... namun ada yang menurut saya masih kurang contoh Rp. 131.000,00 terbilangnya seratus tiga puluh seribu Rupiah, menurut saya terbilangnya Seratus Tiga Puluh satu Ribu Rupiah... 

mohon masukannya..

 

 

On Thursday, July 25, 2019, 11:52:52 AM GMT+7, Zainul Ulum zainul_ulum@yahoo..com [belajar-excel] <belajar-excel@yahoogroups.com> wrote:

 

 

 

Mas Imam,

Sudah aku tulis di https://cadex.co/2017/10/15/xls-pmg-08-fungsi-terbilang-di-excel-tanpa-macro-versi-mega-formula-rev-03/

Untuk penjelasannya.

Terimakasih,

-zainul

 

 

Sent from Mail for Windows 10

 

From: imam cahyo yuwono chyywn@yahoo.com [belajar-excel]
Sent: Thursday, July 25, 2019 10:12 AM
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] Mega Formula terbilang (terbilang tanpa macro)

 

 

Dear para expert mohon bantuan penjelasan tentang formula terbilang dibawah ini

mohon pencerahan fungsi formula dan perbaikan pada formula yang ada

 

Terima kasih 

 

 
#yiv7436276588 #yiv7436276588 -- #yiv7436276588ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7436276588 #yiv7436276588ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7436276588 #yiv7436276588ygrp-mkp #yiv7436276588hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7436276588 #yiv7436276588ygrp-mkp #yiv7436276588ads {margin-bottom:10px;}#yiv7436276588 #yiv7436276588ygrp-mkp .yiv7436276588ad {padding:0 0;}#yiv7436276588 #yiv7436276588ygrp-mkp .yiv7436276588ad p {margin:0;}#yiv7436276588 #yiv7436276588ygrp-mkp .yiv7436276588ad a {color:#0000ff;text-decoration:none;}#yiv7436276588 #yiv7436276588ygrp-sponsor #yiv7436276588ygrp-lc {font-family:Arial;}#yiv7436276588 #yiv7436276588ygrp-sponsor #yiv7436276588ygrp-lc #yiv7436276588hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7436276588 #yiv7436276588ygrp-sponsor #yiv7436276588ygrp-lc .yiv7436276588ad {margin-bottom:10px;padding:0 0;}#yiv7436276588 #yiv7436276588actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7436276588 #yiv7436276588activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7436276588 #yiv7436276588activity span {font-weight:700;}#yiv7436276588 #yiv7436276588activity span:first-child {text-transform:uppercase;}#yiv7436276588 #yiv7436276588activity span a {color:#5085b6;text-decoration:none;}#yiv7436276588 #yiv7436276588activity span span {color:#ff7900;}#yiv7436276588 #yiv7436276588activity span .yiv7436276588underline {text-decoration:underline;}#yiv7436276588 .yiv7436276588attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7436276588 .yiv7436276588attach div a {text-decoration:none;}#yiv7436276588 .yiv7436276588attach img {border:none;padding-right:5px;}#yiv7436276588 .yiv7436276588attach label {display:block;margin-bottom:5px;}#yiv7436276588 .yiv7436276588attach label a {text-decoration:none;}#yiv7436276588 blockquote {margin:0 0 0 4px;}#yiv7436276588 .yiv7436276588bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7436276588 .yiv7436276588bold a {text-decoration:none;}#yiv7436276588 dd.yiv7436276588last p a {font-family:Verdana;font-weight:700;}#yiv7436276588 dd..yiv7436276588last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7436276588 dd.yiv7436276588last p span.yiv7436276588yshortcuts {margin-right:0;}#yiv7436276588 div.yiv7436276588attach-table div div a {text-decoration:none;}#yiv7436276588 div.yiv7436276588attach-table {width:400px;}#yiv7436276588 div.yiv7436276588file-title a, #yiv7436276588 div.yiv7436276588file-title a:active, #yiv7436276588 div.yiv7436276588file-title a:hover, #yiv7436276588 div.yiv7436276588file-title a:visited {text-decoration:none;}#yiv7436276588 div.yiv7436276588photo-title a, #yiv7436276588 div.yiv7436276588photo-title a:active, #yiv7436276588 div.yiv7436276588photo-title a:hover, #yiv7436276588 div.yiv7436276588photo-title a:visited {text-decoration:none;}#yiv7436276588 div#yiv7436276588ygrp-mlmsg #yiv7436276588ygrp-msg p a span.yiv7436276588yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7436276588 .yiv7436276588green {color:#628c2a;}#yiv7436276588 .yiv7436276588MsoNormal {margin:0 0 0 0;}#yiv7436276588 o {font-size:0;}#yiv7436276588 #yiv7436276588photos div {float:left;width:72px;}#yiv7436276588 #yiv7436276588photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv7436276588 #yiv7436276588photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7436276588 #yiv7436276588reco-category {font-size:77%;}#yiv7436276588 #yiv7436276588reco-desc {font-size:77%;}#yiv7436276588 .yiv7436276588replbq {margin:4px;}#yiv7436276588 #yiv7436276588ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7436276588 #yiv7436276588ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7436276588 #yiv7436276588ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7436276588 #yiv7436276588ygrp-mlmsg select, #yiv7436276588 input, #yiv7436276588 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7436276588 #yiv7436276588ygrp-mlmsg pre, #yiv7436276588 code {font:115% monospace;}#yiv7436276588 #yiv7436276588ygrp-mlmsg * {line-height:1.22em;}#yiv7436276588 #yiv7436276588ygrp-mlmsg #yiv7436276588logo {padding-bottom:10px;}#yiv7436276588 #yiv7436276588ygrp-msg p a {font-family:Verdana;}#yiv7436276588 #yiv7436276588ygrp-msg p#yiv7436276588attach-count span {color:#1E66AE;font-weight:700;}#yiv7436276588 #yiv7436276588ygrp-reco #yiv7436276588reco-head {color:#ff7900;font-weight:700;}#yiv7436276588 #yiv7436276588ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7436276588 #yiv7436276588ygrp-sponsor #yiv7436276588ov li a {font-size:130%;text-decoration:none;}#yiv7436276588 #yiv7436276588ygrp-sponsor #yiv7436276588ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7436276588 #yiv7436276588ygrp-sponsor #yiv7436276588ov ul {margin:0;padding:0 0 0 8px;}#yiv7436276588 #yiv7436276588ygrp-text {font-family:Georgia;}#yiv7436276588 #yiv7436276588ygrp-text p {margin:0 0 1em 0;}#yiv7436276588 #yiv7436276588ygrp-text tt {font-size:120%;}#yiv7436276588 #yiv7436276588ygrp-vital ul li:last-child {border-right:none !important;}#yiv7436276588

Mon Jul 29, 2019 11:56 pm (PDT) . Posted by:

"Stephen Saputro"

Pak Kid,

Problem Solved. Terima kasih Pak Kid.

On Tue, Jul 30, 2019 at 1:22 AM 'Mr. Kid' mr.nmkid@gmail.com
[belajar-excel] <belajar-excel@yahoogroups.com> wrote:

>
>
> terlampir
>
> On Mon, Jul 29, 2019 at 4:05 PM Stephen Saputro stephensaputro@gmail.com
> [belajar-excel] <belajar-excel@yahoogroups.com> wrote:
>
>>
>>
>> Hanya ada ini aja Pak Kid,
>>
>> [image: image.png]
>>
>> On Mon, Jul 29, 2019 at 2:18 PM 'Mr. Kid' mr.nmkid@gmail.com
>> [belajar-excel] <belajar-excel@yahoogroups..com
>> <belajar-excel@yahoogroups.com>> wrote:
>>
>>>
>>>
>>> di cek di worksheet yang ada pivot table-nya......
>>>
>>>
>>> On Mon, Jul 29, 2019 at 1:49 PM Stephen Saputro
>>> stephensaputro@gmail..com <stephensaputro@gmail.com> [belajar-excel] <
>>> belajar-excel@yahoogroups.com> wrote:
>>>
>>>>
>>>>
>>>> Pak Kid,
>>>>
>>>> Sudah saya cek tapi gak ada, saya cuman pake 1 event di thisworkbook
>>>>
>>>> [image: image.png]
>>>>
>>>> Sebenar nya masih bisa di skip sih masalah ini, hanya saja sedikit
>>>> mengganggu,
>>>>
>>>> On Mon, Jul 29, 2019 at 10:52 AM 'Mr. Kid' mr.nmkid@gmail.com
>>>> [belajar-excel] <belajar-excel@yahoogroups.com
>>>> <belajar-excel@yahoogroups..com>> wrote:
>>>>
>>>>>
>>>>>
>>>>> Mungkin ada 2 event di sheet itu.
>>>>>
>>>>> Sent from my smart enough phone
>>>>>
>>>>> On Jul 29, 2019, at 10:11, Stephen Saputro stephensaputro@gmail.com
>>>>> [belajar-excel] <belajar-excel@yahoogroups.com> wrote:
>>>>>
>>>>>
>>>>>
>>>>> Pak Kid,
>>>>>
>>>>> Saya coba script di bawah ini dan berhasil :
>>>>>
>>>>> Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal
>>>>> Target As Range, Cancel As Boolean)
>>>>>
>>>>> On Error Resume Next
>>>>> If Left(Target.Value, 2) = "\\" Then
>>>>> ActiveWorkbook.FollowHyperlink Address:=Target..Value, NewWindow:=True
>>>>> End If
>>>>>
>>>>> End Sub
>>>>>
>>>>> Tapi setelah saya melakukan script yang sama di kertas kerja yang
>>>>> sesungguhnya, kenapa kotak dialog di bawah ini jadi muncul dua kali ya Pak ?
>>>>>
>>>>> <image.png>
>>>>>
>>>>> On Thu, Feb 21, 2019 at 2:46 PM Stephen Saputro <
>>>>> stephensaputro@gmail.com> wrote:
>>>>>
>>>>>> Pak Kid,
>>>>>>
>>>>>> Terima kasih untuk clue nya. Akan coba saya cerna dulu ya Pak.
>>>>>>
>>>>>>
>>>>>> Regards
>>>>>> Adi
>>>>>>
>>>>>> On Thu, Feb 21, 2019 at 1:49 PM 'Mr. Kid' mr.nmkid@gmail..com
>>>>>> [belajar-excel] <belajar-excel@yahoogroups..com
>>>>>> <belajar-excel@yahoogroups.com>> wrote:
>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> harus tahu nama field yang berisi teks url nya
>>>>>>> supaya bisa membatasi kerja event di area field itu saja.
>>>>>>> pakai error trap juga, supaya gak ribet harus periksa apakah cells
>>>>>>> yang ditunjuk berisi url atau sekadar teks biasa.
>>>>>>>
>>>>>>> Regards,
>>>>>>> Kid
>>>>>>>
>>>>>>>
>>>>>>> On Wed, Feb 20, 2019 at 12:10 PM Stephen Saputro
>>>>>>> stephensaputro@gmail.com [belajar-excel] <
>>>>>>> belajar-excel@yahoogroups.com> wrote:
>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> Dear Teman2 Milis,
>>>>>>>>
>>>>>>>> Mohon dapat di bantu kasus saya, Saya sedang membuat pivot, yang di
>>>>>>>> dalamnya ada hyperlink yang jika di klik akan membuka suatu document. Untuk
>>>>>>>> mengaktivkan hyperlink di pivot, saya menggunakan script di bawah ini :
>>>>>>>>
>>>>>>>>
>>>>>>>> ----------------------------------------------------------
>>>>>>>> Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal
>>>>>>>> Target As Range)
>>>>>>>>
>>>>>>>> Dim ptc As PivotTable, Value As Variant, Rng As Range
>>>>>>>> For Each ptc In Worksheets(Sh.Name).PivotTables
>>>>>>>> If Not Intersect(Target, Range(ptc........TableRange1.Address)) Is
>>>>>>>> Nothing Then
>>>>>>>> If Left(Target.Value, 2) = "\&#92;" Then
>>>>>>>> ActiveWorkbook.FollowHyperlink Address:=Target.Value,
>>>>>>>> NewWindow:=True
>>>>>>>> End If
>>>>>>>> End If
>>>>>>>> Next ptc
>>>>>>>> End Sub
>>>>>>>>
>>>>>>>>
>>>>>>>> ----------------------------------------------------------
>>>>>>>>
>>>>>>>> Hanya saja ada beberapa masalah yang saya hadapi.
>>>>>>>>
>>>>>>>> 1. ketika saya melakukan select range di pivot, maka yang muncul
>>>>>>>> adalah seperti ini :
>>>>>>>>
>>>>>>>> Select range
>>>>>>>> <image.png>
>>>>>>>>
>>>>>>>> Message 1
>>>>>>>> <image.png>
>>>>>>>>
>>>>>>>> 2.. Waktu hyperlink di klik, akan keluar Ok or Cancel, dan waktu
>>>>>>>> cancel di klik, maka yang muncul adalah seperti ini :
>>>>>>>>
>>>>>>>> <image.png>
>>>>>>>>
>>>>>>>> Message 2
>>>>>>>> <image.png>
>>>>>>>>
>>>>>>>> Mohon bantuan teman teman semuanya, bagaimana agar cara nya
>>>>>>>> menghilangkan error ini agar message 1 dan juga message 2 tidak muncul lagi
>>>>>>>>
>>>>>>>>
>>>>>>>> Terima kasih
>>>>>>>>
>>>>>>>>
>

Tue Jul 30, 2019 6:02 am (PDT) . Posted by:

"Adi Tahajudin"

Apakah Bisa UserForm Lookup Ke Data Excel, Seperti Rumus = (samadengan)
============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------
Diposting oleh EXCEL FEED LEARNING di 22.08

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)