Re: [belajar-excel] Mohon Bantuan Memberi Kode Wilayah [1 Attachment]

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Mohon Bantuan Memberi Kode Wilayah [1 Attachment]

aza_faza
Dear All......
Ada pertanyaan apa formula yg dipakai untuk menambahkan suatu kode di kolom sebelumnya...
Maaf untuk file terlampir...
Terimakasih sebelumnya
Salam

=?UTF-8?b?QmVyaSBLb2RlIFdpbGF5YWgueGxzeA==?= (14K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

RE: [belajar-excel] Mohon Bantuan Memberi Kode Wilayah [2 Attachments]

Zainul Ulum
Azafa,
Coba file terlampir.
Thanks,
-zainul


Sent from Mail for Windows 10

From: azafaza [hidden email] [belajar-excel]
Sent: Thursday, June 11, 2020 6:22 AM
To: BeExcel
Subject: Re: [belajar-excel] Mohon Bantuan Memberi Kode Wilayah [1 Attachment]

 
Dear All......
Ada pertanyaan apa formula yg dipakai untuk menambahkan suatu kode di kolom sebelumnya...
Maaf untuk file terlampir...
Terimakasih sebelumnya
Salam



Copy of Beri Kode Wilayah.xlsx (18K) Download Attachment
35B949AD4EDC4B18864444101C0B3AFE.png (198 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Mohon Bantuan Memberi Kode Wilayah

aza_faza
In reply to this post by aza_faza
Terima Kasih... Mas Zainul
ternyata gampang banget ya..hahaa
 

    Pada Kamis, 11 Juni 2020 10.37.56 WIT, Zainul Ulum [hidden email] [belajar-excel] <[hidden email]> menulis:  
 
    


Azafa,

Coba file terlampir.

Thanks,

-zainul

  

  

Sent from Mail for Windows 10

  

From: azafaza [hidden email] [belajar-excel]
Sent: Thursday, June 11, 2020 6:22 AM
To: BeExcel
Subject: Re: [belajar-excel] Mohon Bantuan Memberi Kode Wilayah [1 Attachment]

  

 

Dear All......

Ada pertanyaan apa formula yg dipakai untuk menambahkan suatu kode di kolom sebelumnya...

Maaf untuk file terlampir...

Terimakasih sebelumnya
Salam



  
  #yiv5164914081 #yiv5164914081 -- #yiv5164914081ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5164914081 #yiv5164914081ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5164914081 #yiv5164914081ygrp-mkp #yiv5164914081hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5164914081 #yiv5164914081ygrp-mkp #yiv5164914081ads {margin-bottom:10px;}#yiv5164914081 #yiv5164914081ygrp-mkp .yiv5164914081ad {padding:0 0;}#yiv5164914081 #yiv5164914081ygrp-mkp .yiv5164914081ad p {margin:0;}#yiv5164914081 #yiv5164914081ygrp-mkp .yiv5164914081ad a {color:#0000ff;text-decoration:none;}#yiv5164914081 #yiv5164914081ygrp-sponsor #yiv5164914081ygrp-lc {font-family:Arial;}#yiv5164914081 #yiv5164914081ygrp-sponsor #yiv5164914081ygrp-lc #yiv5164914081hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5164914081 #yiv5164914081ygrp-sponsor #yiv5164914081ygrp-lc .yiv5164914081ad {margin-bottom:10px;padding:0 0;}#yiv5164914081 #yiv5164914081actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5164914081 #yiv5164914081activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5164914081 #yiv5164914081activity span {font-weight:700;}#yiv5164914081 #yiv5164914081activity span:first-child {text-transform:uppercase;}#yiv5164914081 #yiv5164914081activity span a {color:#5085b6;text-decoration:none;}#yiv5164914081 #yiv5164914081activity span span {color:#ff7900;}#yiv5164914081 #yiv5164914081activity span .yiv5164914081underline {text-decoration:underline;}#yiv5164914081 .yiv5164914081attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5164914081 .yiv5164914081attach div a {text-decoration:none;}#yiv5164914081 .yiv5164914081attach img {border:none;padding-right:5px;}#yiv5164914081 .yiv5164914081attach label {display:block;margin-bottom:5px;}#yiv5164914081 .yiv5164914081attach label a {text-decoration:none;}#yiv5164914081 blockquote {margin:0 0 0 4px;}#yiv5164914081 .yiv5164914081bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5164914081 .yiv5164914081bold a {text-decoration:none;}#yiv5164914081 dd.yiv5164914081last p a {font-family:Verdana;font-weight:700;}#yiv5164914081 dd.yiv5164914081last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5164914081 dd.yiv5164914081last p span.yiv5164914081yshortcuts {margin-right:0;}#yiv5164914081 div.yiv5164914081attach-table div div a {text-decoration:none;}#yiv5164914081 div.yiv5164914081attach-table {width:400px;}#yiv5164914081 div.yiv5164914081file-title a, #yiv5164914081 div.yiv5164914081file-title a:active, #yiv5164914081 div.yiv5164914081file-title a:hover, #yiv5164914081 div.yiv5164914081file-title a:visited {text-decoration:none;}#yiv5164914081 div.yiv5164914081photo-title a, #yiv5164914081 div.yiv5164914081photo-title a:active, #yiv5164914081 div.yiv5164914081photo-title a:hover, #yiv5164914081 div.yiv5164914081photo-title a:visited {text-decoration:none;}#yiv5164914081 div#yiv5164914081ygrp-mlmsg #yiv5164914081ygrp-msg p a span.yiv5164914081yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5164914081 .yiv5164914081green {color:#628c2a;}#yiv5164914081 .yiv5164914081MsoNormal {margin:0 0 0 0;}#yiv5164914081 o {font-size:0;}#yiv5164914081 #yiv5164914081photos div {float:left;width:72px;}#yiv5164914081 #yiv5164914081photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv5164914081 #yiv5164914081photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5164914081 #yiv5164914081reco-category {font-size:77%;}#yiv5164914081 #yiv5164914081reco-desc {font-size:77%;}#yiv5164914081 .yiv5164914081replbq {margin:4px;}#yiv5164914081 #yiv5164914081ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5164914081 #yiv5164914081ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5164914081 #yiv5164914081ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5164914081 #yiv5164914081ygrp-mlmsg select, #yiv5164914081 input, #yiv5164914081 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5164914081 #yiv5164914081ygrp-mlmsg pre, #yiv5164914081 code {font:115% monospace;}#yiv5164914081 #yiv5164914081ygrp-mlmsg * {line-height:1.22em;}#yiv5164914081 #yiv5164914081ygrp-mlmsg #yiv5164914081logo {padding-bottom:10px;}#yiv5164914081 #yiv5164914081ygrp-msg p a {font-family:Verdana;}#yiv5164914081 #yiv5164914081ygrp-msg p#yiv5164914081attach-count span {color:#1E66AE;font-weight:700;}#yiv5164914081 #yiv5164914081ygrp-reco #yiv5164914081reco-head {color:#ff7900;font-weight:700;}#yiv5164914081 #yiv5164914081ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5164914081 #yiv5164914081ygrp-sponsor #yiv5164914081ov li a {font-size:130%;text-decoration:none;}#yiv5164914081 #yiv5164914081ygrp-sponsor #yiv5164914081ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5164914081 #yiv5164914081ygrp-sponsor #yiv5164914081ov ul {margin:0;padding:0 0 0 8px;}#yiv5164914081 #yiv5164914081ygrp-text {font-family:Georgia;}#yiv5164914081 #yiv5164914081ygrp-text p {margin:0 0 1em 0;}#yiv5164914081 #yiv5164914081ygrp-text tt {font-size:120%;}#yiv5164914081 #yiv5164914081ygrp-vital ul li:last-child {border-right:none !important;}#yiv5164914081  
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Mohon Bantuan Memberi Kode Wilayah

Bagus-2
Dear Faza;

Coba begini =If(left(n4)=">",n4,if(left(n4)=" ",m3,""))
Copas kebawah.


Wassalam
   Bagus


Pada tanggal Kam, 11 Jun 2020 pukul 08.45 azafaza [hidden email]
[belajar-excel] <[hidden email]> menulis:

>
>
> Terima Kasih... Mas Zainul
> ternyata gampang banget ya..hahaa
>
>
> Pada Kamis, 11 Juni 2020 10.37.56 WIT, Zainul Ulum [hidden email]
> [belajar-excel] <[hidden email]> menulis:
>
>
>
>
> Azafa,
>
> Coba file terlampir.
>
> Thanks,
>
> -zainul
>
>
>
>
>
> Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for
> Windows 10
>
>
>
> *From: *azafaza [hidden email] [belajar-excel]
> <[hidden email]>
> *Sent: *Thursday, June 11, 2020 6:22 AM
> *To: *BeExcel <[hidden email]>
> *Subject: *Re: [belajar-excel] Mohon Bantuan Memberi Kode Wilayah [1
> Attachment]
>
>
>
>
>
> Dear All......
>
> Ada pertanyaan apa formula yg dipakai untuk menambahkan suatu kode di
> kolom sebelumnya...
>
> Maaf untuk file terlampir...
>
> Terimakasih sebelumnya
> Salam
>
>
>
>
>