[belajar-excel] Transpose data [1 Attachment]

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

[belajar-excel] Transpose data [1 Attachment]

Milis Belajar Excel mailing list
Dear Master Excel

Tolong dibantu bagaimana cara nya mengubah data "sheet" sebelum dengan
"sheet Hasil"


terima kasih sebelum nya

Transpose Data.xlsx (17K) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [belajar-excel] Transpose data [1 Attachment]

Milis Belajar Excel mailing list
Hai Hita,

File terlampir adalah contoh pemanfaatan approximate match pada
fungsi-fungsi lookup & references seperti Match, LookUp, vLookUp dan
sebagainya.

Regards,
Kid


2017-07-19 16:53 GMT+07:00 halak hita [hidden email]
[belajar-excel] <[hidden email]>:

>
>
> Dear Master Excel
>
> Tolong dibantu bagaimana cara nya mengubah data "sheet" sebelum dengan
> "sheet Hasil"
>
>
> terima kasih sebelum nya
>
>
>

re-Transpose Data.xlsx (25K) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [belajar-excel] Transpose data

Milis Belajar Excel mailing list
Hi mr.kid


Selamat siang dan terima kasih sudah diberikan pencerahan,


=IF(ROW()-ROW(M$5)<$M$4,MATCH(TEXT(ROW()-ROW(M$5),"00000"),_tblDT_
*[[#All],[00001]]*),0)


pak, bisa dibantu apa maksud dari rumus [[#All],[00001]]






salam
hh




2017-07-22 8:29 GMT+07:00 'Mr. Kid' [hidden email] [belajar-excel] <
[hidden email]>:


>
>
> Hai Hita,
>
> File terlampir adalah contoh pemanfaatan approximate match pada
> fungsi-fungsi lookup & references seperti Match, LookUp, vLookUp dan
> sebagainya.
>
> Regards,
> Kid
>
>
> 2017-07-19 16:53 GMT+07:00 halak hita [hidden email]
> [belajar-excel] <[hidden email]>:
>
>>
>>
>> Dear Master Excel
>>
>> Tolong dibantu bagaimana cara nya mengubah data "sheet" sebelum dengan
>> "sheet Hasil"
>>
>>
>> terima kasih sebelum nya
>>
>>
>
>
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [belajar-excel] Transpose data

Milis Belajar Excel mailing list
Seluruh baris di kolom [00001] dalam object excel table _tblDT_

Coba pelajari tentang fitur object Excel Table

Sent from my smart enough phone

> On Jul 24, 2017, at 11:38, halak hita [hidden email] [belajar-excel] <[hidden email]> wrote:
>
> Hi mr.kid
>
> Selamat siang dan terima kasih sudah diberikan pencerahan,
>
> =IF(ROW()-ROW(M$5)<$M$4,MATCH(TEXT(ROW()-ROW(M$5),"00000"),_tblDT_[[#All],[00001]]),0)
>
> pak, bisa dibantu apa maksud dari rumus [[#All],[00001]]
>
>
>
> salam
> hh
>
>
> 2017-07-22 8:29 GMT+07:00 'Mr. Kid' [hidden email] [belajar-excel] <[hidden email]>:
>>  
>> Hai Hita,
>>
>> File terlampir adalah contoh pemanfaatan approximate match pada fungsi-fungsi lookup & references seperti Match, LookUp, vLookUp dan sebagainya.
>>
>> Regards,
>> Kid
>>
>>
>> 2017-07-19 16:53 GMT+07:00 halak hita [hidden email] [belajar-excel] <[hidden email]>:
>>>  
>>> Dear Master Excel
>>>
>>> Tolong dibantu bagaimana cara nya mengubah data "sheet" sebelum dengan "sheet Hasil"
>>>
>>>
>>> terima kasih sebelum nya
>>>
>>
>
>
Loading...