; Thanks,
>
> -zainul
>
>
>
>
>
> Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for
> Windows 10
>
>
>
> *From: *halak hita halakhita1...@gmail.com [belajar-excel]
>
> *Sent: *Wednesday, May 13, 2020 2:26 PM
> *To: *belajar-excel@yahoogroups.
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 ghozialkat...@yahoo.co.id
[belajar-excel] wrote:
>
>
> tulis di K3
>
> =SUBSTITUTE(TRIM(IF(LEN(C3),C$2&" ","")&IF(LEN(D3),D$2&"
>
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 AlkatiriPada Rabu, 13 Mei 2020 14.26.35 WIB, halak hita
halakhita1...@gmail.com [belajar-excel]
menuli
HH,
Terlampir contoh menggunakan power query tanpa ada rumus.
Thanks,
-zainul
Sent from Mail for Windows 10
From: halak hita halakhita1...@gmail.com [belajar-excel]
Sent: Wednesday, May 13, 2020 2:26 PM
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] Rumus menetapkan Lokasi lebih
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
Description: MS-Excel 2007 spreadsheet
5 matches
Mail list logo