[belajar-excel] Rumus menetapkan Lokasi lebih dari satu [1 Attachment]

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

[belajar-excel] Rumus menetapkan Lokasi lebih dari satu [1 Attachment]

halak hita
Selamat Siang Para Master
Mohon dibantu, bagaimana rumus menetapkan nama lokasi sesuai dalam lampiran
berikut.

File terlampir dan hasil yang diinginkan sesuai pada warna hijau.

Terima kasih
HH

Menentukan nama Lokasi.xlsx (15K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

RE: [belajar-excel] Rumus menetapkan Lokasi lebih dari satu [2 Attachments]

Zainul Ulum
HH,
Terlampir contoh menggunakan power query tanpa ada rumus.
Thanks,
-zainul


Sent from Mail for Windows 10

From: halak hita [hidden email] [belajar-excel]
Sent: Wednesday, May 13, 2020 2:26 PM
To: [hidden email]
Subject: [belajar-excel] Rumus menetapkan Lokasi lebih dari satu [1 Attachment]

 
Selamat Siang Para Master
Mohon dibantu, bagaimana rumus menetapkan nama lokasi sesuai dalam lampiran berikut.

File terlampir dan hasil yang diinginkan sesuai pada warna hijau.

Terima kasih
HH



Menentukan nama Lokasi(PQ).xlsx (30K) Download Attachment
C6CF4B1D4B524F6ABD72550A23A3C27B.png (206 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Rumus menetapkan Lokasi lebih dari satu

ghozi alkatiri
In reply to this post by halak hita
 tulis di K3 
=SUBSTITUTE(TRIM(IF(LEN(C3),C$2&" ","")&IF(LEN(D3),D$2&" ","")&IF(LEN(E3),E$2&" ","")&IF(LEN(F3),F$2&" ","")&IF(LEN(G3),G$2&" ",""))," ",",")

coppy ke bawah
wasssalam 
Ghozi Alkatiri    Pada Rabu, 13 Mei 2020 14.26.35 WIB, halak hita [hidden email] [belajar-excel] <[hidden email]> menulis:  
 
    

Selamat Siang Para MasterMohon dibantu, bagaimana rumus menetapkan nama lokasi sesuai dalam lampiran berikut.
File terlampir dan hasil yang diinginkan sesuai pada warna hijau.
Terima kasihHH  #yiv6205825988 #yiv6205825988 -- #yiv6205825988ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6205825988 #yiv6205825988ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6205825988 #yiv6205825988ygrp-mkp #yiv6205825988hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6205825988 #yiv6205825988ygrp-mkp #yiv6205825988ads {margin-bottom:10px;}#yiv6205825988 #yiv6205825988ygrp-mkp .yiv6205825988ad {padding:0 0;}#yiv6205825988 #yiv6205825988ygrp-mkp .yiv6205825988ad p {margin:0;}#yiv6205825988 #yiv6205825988ygrp-mkp .yiv6205825988ad a {color:#0000ff;text-decoration:none;}#yiv6205825988 #yiv6205825988ygrp-sponsor #yiv6205825988ygrp-lc {font-family:Arial;}#yiv6205825988 #yiv6205825988ygrp-sponsor #yiv6205825988ygrp-lc #yiv6205825988hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6205825988 #yiv6205825988ygrp-sponsor #yiv6205825988ygrp-lc .yiv6205825988ad {margin-bottom:10px;padding:0 0;}#yiv6205825988 #yiv6205825988actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6205825988 #yiv6205825988activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6205825988 #yiv6205825988activity span {font-weight:700;}#yiv6205825988 #yiv6205825988activity span:first-child {text-transform:uppercase;}#yiv6205825988 #yiv6205825988activity span a {color:#5085b6;text-decoration:none;}#yiv6205825988 #yiv6205825988activity span span {color:#ff7900;}#yiv6205825988 #yiv6205825988activity span .yiv6205825988underline {text-decoration:underline;}#yiv6205825988 .yiv6205825988attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6205825988 .yiv6205825988attach div a {text-decoration:none;}#yiv6205825988 .yiv6205825988attach img {border:none;padding-right:5px;}#yiv6205825988 .yiv6205825988attach label {display:block;margin-bottom:5px;}#yiv6205825988 .yiv6205825988attach label a {text-decoration:none;}#yiv6205825988 blockquote {margin:0 0 0 4px;}#yiv6205825988 .yiv6205825988bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6205825988 .yiv6205825988bold a {text-decoration:none;}#yiv6205825988 dd.yiv6205825988last p a {font-family:Verdana;font-weight:700;}#yiv6205825988 dd.yiv6205825988last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6205825988 dd.yiv6205825988last p span.yiv6205825988yshortcuts {margin-right:0;}#yiv6205825988 div.yiv6205825988attach-table div div a {text-decoration:none;}#yiv6205825988 div.yiv6205825988attach-table {width:400px;}#yiv6205825988 div.yiv6205825988file-title a, #yiv6205825988 div.yiv6205825988file-title a:active, #yiv6205825988 div.yiv6205825988file-title a:hover, #yiv6205825988 div.yiv6205825988file-title a:visited {text-decoration:none;}#yiv6205825988 div.yiv6205825988photo-title a, #yiv6205825988 div.yiv6205825988photo-title a:active, #yiv6205825988 div.yiv6205825988photo-title a:hover, #yiv6205825988 div.yiv6205825988photo-title a:visited {text-decoration:none;}#yiv6205825988 div#yiv6205825988ygrp-mlmsg #yiv6205825988ygrp-msg p a span.yiv6205825988yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6205825988 .yiv6205825988green {color:#628c2a;}#yiv6205825988 .yiv6205825988MsoNormal {margin:0 0 0 0;}#yiv6205825988 o {font-size:0;}#yiv6205825988 #yiv6205825988photos div {float:left;width:72px;}#yiv6205825988 #yiv6205825988photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv6205825988 #yiv6205825988photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6205825988 #yiv6205825988reco-category {font-size:77%;}#yiv6205825988 #yiv6205825988reco-desc {font-size:77%;}#yiv6205825988 .yiv6205825988replbq {margin:4px;}#yiv6205825988 #yiv6205825988ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6205825988 #yiv6205825988ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6205825988 #yiv6205825988ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6205825988 #yiv6205825988ygrp-mlmsg select, #yiv6205825988 input, #yiv6205825988 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6205825988 #yiv6205825988ygrp-mlmsg pre, #yiv6205825988 code {font:115% monospace;}#yiv6205825988 #yiv6205825988ygrp-mlmsg * {line-height:1.22em;}#yiv6205825988 #yiv6205825988ygrp-mlmsg #yiv6205825988logo {padding-bottom:10px;}#yiv6205825988 #yiv6205825988ygrp-msg p a {font-family:Verdana;}#yiv6205825988 #yiv6205825988ygrp-msg p#yiv6205825988attach-count span {color:#1E66AE;font-weight:700;}#yiv6205825988 #yiv6205825988ygrp-reco #yiv6205825988reco-head {color:#ff7900;font-weight:700;}#yiv6205825988 #yiv6205825988ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6205825988 #yiv6205825988ygrp-sponsor #yiv6205825988ov li a {font-size:130%;text-decoration:none;}#yiv6205825988 #yiv6205825988ygrp-sponsor #yiv6205825988ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6205825988 #yiv6205825988ygrp-sponsor #yiv6205825988ov ul {margin:0;padding:0 0 0 8px;}#yiv6205825988 #yiv6205825988ygrp-text {font-family:Georgia;}#yiv6205825988 #yiv6205825988ygrp-text p {margin:0 0 1em 0;}#yiv6205825988 #yiv6205825988ygrp-text tt {font-size:120%;}#yiv6205825988 #yiv6205825988ygrp-vital ul li:last-child {border-right:none !important;}#yiv6205825988  
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Rumus menetapkan Lokasi lebih dari satu

halak hita
Salam

Terima kasih kepada Master Ghozi Alkatiri karena telah membantu dan
hasilnya sesuai seperti yang diharapkan


HH

On Thu, May 14, 2020 at 7:12 AM ghozi alkatiri [hidden email]
[belajar-excel] <[hidden email]> wrote:

>
>
> tulis di K3
>
> =SUBSTITUTE(TRIM(IF(LEN(C3),C$2&" ","")&IF(LEN(D3),D$2&"
> ","")&IF(LEN(E3),E$2&" ","")&IF(LEN(F3),F$2&" ","")&IF(LEN(G3),G$2&"
> ",""))," ",",")
>
> coppy ke bawah
>
> wasssalam
>
> Ghozi Alkatiri
> Pada Rabu, 13 Mei 2020 14.26.35 WIB, halak hita [hidden email]
> [belajar-excel] <[hidden email]> menulis:
>
>
>
>
> Selamat Siang Para Master
> Mohon dibantu, bagaimana rumus menetapkan nama lokasi sesuai dalam
> lampiran berikut.
>
> File terlampir dan hasil yang diinginkan sesuai pada warna hijau.
>
> Terima kasih
> HH
>
>
>
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Rumus menetapkan Lokasi lebih dari satu

halak hita
In reply to this post by halak hita
Salam

Terima kasih kepada master Zainul karena telah memberikan masukan tentang
PQ,

Salam
HH

On Wed, May 13, 2020 at 6:03 PM Zainul Ulum [hidden email]
[belajar-excel] <[hidden email]> wrote:

>
>
> HH,
>
> Terlampir contoh menggunakan power query tanpa ada rumus.
>
> Thanks,
>
> -zainul
>
>
>
>
>
> Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for
> Windows 10
>
>
>
> *From: *halak hita [hidden email] [belajar-excel]
> <[hidden email]>
> *Sent: *Wednesday, May 13, 2020 2:26 PM
> *To: *[hidden email]
> *Subject: *[belajar-excel] Rumus menetapkan Lokasi lebih dari satu [1
> Attachment]
>
>
>
>
>
> Selamat Siang Para Master
>
> Mohon dibantu, bagaimana rumus menetapkan nama lokasi sesuai dalam
> lampiran berikut.
>
>
>
> File terlampir dan hasil yang diinginkan sesuai pada warna hijau.
>
>
>
> Terima kasih
>
> HH
>
>
>
>
>