[belajar-excel] rekap laporan [1 Attachment]

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

[belajar-excel] rekap laporan [1 Attachment]

pay
dear be exceller

saya mw ambil data terbaru berdasarkan tanggal dengan pivot caranya gimana
ya mohon bimbinganya atas perhatiannya terimakasih
file terlampir

coba.xlsx (78K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

RE: [belajar-excel] rekap laporan

M.Ade Alfarid
Dear,

maksud mw ambil data terbaru itu bagaimana ya?

Mw diambil tujuannya apa? Mw dikemanakan? (mohon maaf gak mudeng….



Mungkin Jika ingin menampilkan yg terbaru bisa di sort saja, pilih sortir
tahun,bulan dan tanggal yg diinginkan.

Apakah begini yg diinginkan?





Ade



*From:* [hidden email] [mailto:[hidden email]]

*Sent:* Wednesday, April 25, 2018 9:46 AM
*To:* [hidden email]
*Subject:* [belajar-excel] rekap laporan [1 Attachment]





dear be exceller

saya mw ambil data terbaru berdasarkan tanggal dengan pivot caranya gimana
ya mohon bimbinganya atas perhatiannya terimakasih

file terlampir



Posted by: fathir ali <[hidden email]>

image001.png (11K) Download Attachment
pay
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] rekap laporan [1 Attachment]

pay
maaf om data salah sy kirimkan lagi
yg di warnai kuning sy mw ambil buat laporan

Pada 25 April 2018 13.15, 'M.Ade Alfarid' [hidden email] [belajar-excel] <
[hidden email]> menulis:

>
>
> Dear,
>
> maksud mw ambil data terbaru itu bagaimana ya?
>
> Mw diambil tujuannya apa? Mw dikemanakan? (mohon maaf gak mudeng….
>
>
>
> Mungkin Jika ingin menampilkan yg terbaru bisa di sort saja, pilih sortir
> tahun,bulan dan tanggal yg diinginkan.
>
> Apakah begini yg diinginkan?
>
>
>
>
>
> Ade
>
>
>
> *From:* belajar-excel@yahoogroups..com <[hidden email]>
> [mailto:[hidden email]]
> *Sent:* Wednesday, April 25, 2018 9:46 AM
> *To:* [hidden email]
> *Subject:* [belajar-excel] rekap laporan [1 Attachment]
>
>
>
>
>
> dear be exceller
>
> saya mw ambil data terbaru berdasarkan tanggal dengan pivot caranya gimana
> ya mohon bimbinganya atas perhatiannya terimakasih
>
> file terlampir
>
>
>
> Posted by: fathir ali <[hidden email]>
>
>
>

image001.png (11K) Download Attachment
coba 1.xlsx (66K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] rekap laporan

Sony Ario
pakek rumus =Max(C:C) gitu ? bisa gak ?

*gnl-excelinfo.blogspot.co.id <http://gnl-excelinfo.blogspot.co.id>*

2018-04-25 14:42 GMT+07:00 fathir ali [hidden email] [belajar-excel]
<[hidden email]>:

>
>
> maaf om data salah sy kirimkan lagi
> yg di warnai kuning sy mw ambil buat laporan
>
> Pada 25 April 2018 13.15, 'M.Ade Alfarid' [hidden email] [belajar-excel] <
> [hidden email]> menulis:
>
>>
>>
>> Dear,
>>
>> maksud mw ambil data terbaru itu bagaimana ya?
>>
>> Mw diambil tujuannya apa? Mw dikemanakan? (mohon maaf gak mudeng….
>>
>>
>>
>> Mungkin Jika ingin menampilkan yg terbaru bisa di sort saja, pilih sortir
>> tahun,bulan dan tanggal yg diinginkan.
>>
>> Apakah begini yg diinginkan?
>>
>>
>>
>>
>>
>> Ade
>>
>>
>>
>> *From:* belajar-excel@yahoogroups..com <[hidden email]>
>> [mailto:[hidden email]]
>> *Sent:* Wednesday, April 25, 2018 9:46 AM
>> *To:* [hidden email]
>> *Subject:* [belajar-excel] rekap laporan [1 Attachment]
>>
>>
>>
>>
>>
>> dear be exceller
>>
>> saya mw ambil data terbaru berdasarkan tanggal dengan pivot caranya
>> gimana ya mohon bimbinganya atas perhatiannya terimakasih
>>
>> file terlampir
>>
>>
>>
>> Posted by: fathir ali <[hidden email]>
>>
>>
>
>

image001.png (11K) Download Attachment
pay
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] rekap laporan

pay
klo dari pivot bisa nga om

Pada tanggal Rab, 25 Apr 2018 16.26, Sony Ario [hidden email]
[belajar-excel] <[hidden email]> menulis:

>
>
> pakek rumus =Max(C:C) gitu ? bisa gak ?
>
> *gnl-excelinfo.blogspot.co.id <http://gnl-excelinfo.blogspot.co.id>*
>
> 2018-04-25 14:42 GMT+07:00 fathir ali [hidden email]
> [belajar-excel] <[hidden email]>:
>
>>
>>
>> maaf om data salah sy kirimkan lagi
>> yg di warnai kuning sy mw ambil buat laporan
>>
>> Pada 25 April 2018 13.15, 'M.Ade Alfarid' QA@kkmi..co.id <[hidden email]>
>> [belajar-excel] <[hidden email]> menulis:
>>
>>>
>>>
>>> Dear,
>>>
>>> maksud mw ambil data terbaru itu bagaimana ya?
>>>
>>> Mw diambil tujuannya apa? Mw dikemanakan? (mohon maaf gak mudeng….
>>>
>>>
>>>
>>> Mungkin Jika ingin menampilkan yg terbaru bisa di sort saja, pilih
>>> sortir tahun,bulan dan tanggal yg diinginkan.
>>>
>>> Apakah begini yg diinginkan?
>>>
>>>
>>>
>>>
>>>
>>> Ade
>>>
>>>
>>>
>>> *From:* belajar-excel@yahoogroups..com <[hidden email]>
>>> [mailto:[hidden email]]
>>> *Sent:* Wednesday, April 25, 2018 9:46 AM
>>> *To:* [hidden email]
>>> *Subject:* [belajar-excel] rekap laporan [1 Attachment]
>>>
>>>
>>>
>>>
>>>
>>> dear be exceller
>>>
>>> saya mw ambil data terbaru berdasarkan tanggal dengan pivot caranya
>>> gimana ya mohon bimbinganya atas perhatiannya terimakasih
>>>
>>> file terlampir
>>>
>>>
>>>
>>> Posted by: fathir ali <[hidden email]>
>>>
>>>
>>
>
>

image001.png (11K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

RE: [belajar-excel] rekap laporan [1 Attachment]

M.Ade Alfarid
In reply to this post by pay
Dear,

Mungkin begini?



Ade



*From:* [hidden email] [mailto:[hidden email]]

*Sent:* Wednesday, April 25, 2018 2:42 PM
*To:* [hidden email]
*Subject:* Re: [belajar-excel] rekap laporan [1 Attachment]





maaf om data salah sy kirimkan lagi

yg di warnai kuning sy mw ambil buat laporan



Pada 25 April 2018 13.15, 'M.Ade Alfarid' [hidden email] [belajar-excel] <
[hidden email]> menulis:



Dear,

maksud mw ambil data terbaru itu bagaimana ya?

Mw diambil tujuannya apa? Mw dikemanakan? (mohon maaf gak mudeng….



Mungkin Jika ingin menampilkan yg terbaru bisa di sort saja, pilih sortir
tahun,bulan dan tanggal yg diinginkan.

Apakah begini yg diinginkan?





Ade



*From:* belajar-excel@yahoogroups..com <[hidden email]>
[mailto:[hidden email]]
*Sent:* Wednesday, April 25, 2018 9:46 AM
*To:* [hidden email]
*Subject:* [belajar-excel] rekap laporan [1 Attachment]





dear be exceller

saya mw ambil data terbaru berdasarkan tanggal dengan pivot caranya gimana
ya mohon bimbinganya atas perhatiannya terimakasih

file terlampir



Posted by: fathir ali <[hidden email]>





View attachments on the web
<https://groups.yahoo.com/neo/groups/belajar-excel/attachments/1580375478;_ylc=X3oDMTJyazBqbWloBF9TAzk3MzU5NzE0BGdycElkAzIwNjI3Njc4BGdycHNwSWQDMTcwODI5ODgyMQRzZWMDYXR0YWNobWVudARzbGsDdmlld09uV2ViBHN0aW1lAzE1MjQ2NDM5OTI->
------------------------------

Posted by: fathir ali <[hidden email]>

image001.png (11K) Download Attachment
re-coba 1.xlsx (71K) Download Attachment
pay
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] rekap laporan

pay
iya om seperti itu caranya gimana ya kasih tau dong

Pada 25 April 2018 16.41, 'M.Ade Alfarid' [hidden email] [belajar-excel] <
[hidden email]> menulis:

>
>
> Dear,
>
> Mungkin begini?
>
>
>
> Ade
>
>
>
> *From:* [hidden email] [mailto:belajar-excel@
> yahoogroups.com]
> *Sent:* Wednesday, April 25, 2018 2:42 PM
> *To:* [hidden email]
> *Subject:* Re: [belajar-excel] rekap laporan [1 Attachment]
>
>
>
>
>
> maaf om data salah sy kirimkan lagi
>
> yg di warnai kuning sy mw ambil buat laporan
>
>
>
> Pada 25 April 2018 13.15, 'M.Ade Alfarid' [hidden email] [belajar-excel] <
> [hidden email]> menulis:
>
>
>
> Dear,
>
> maksud mw ambil data terbaru itu bagaimana ya?
>
> Mw diambil tujuannya apa? Mw dikemanakan? (mohon maaf gak mudeng…..
>
>
>
> Mungkin Jika ingin menampilkan yg terbaru bisa di sort saja, pilih sortir
> tahun,bulan dan tanggal yg diinginkan.
>
> Apakah begini yg diinginkan?
>
>
>
>
>
> Ade
>
>
>
> *From:* belajar-excel@yahoogroups..com <[hidden email]>
> [mailto:[hidden email]]
> *Sent:* Wednesday, April 25, 2018 9:46 AM
> *To:* [hidden email]
> *Subject:* [belajar-excel] rekap laporan [1 Attachment]
>
>
>
>
>
> dear be exceller
>
> saya mw ambil data terbaru berdasarkan tanggal dengan pivot caranya gimana
> ya mohon bimbinganya atas perhatiannya terimakasih
>
> file terlampir
>
>
>
> Posted by: fathir ali <[hidden email]>
>
>
>
> View attachments on the web
> <https://groups.yahoo.com/neo/groups/belajar-excel/attachments/1580375478;_ylc=X3oDMTJyazBqbWloBF9TAzk3MzU5NzE0BGdycElkAzIwNjI3Njc4BGdycHNwSWQDMTcwODI5ODgyMQRzZWMDYXR0YWNobWVudARzbGsDdmlld09uV2ViBHN0aW1lAzE1MjQ2NDM5OTI->
> ------------------------------
>
> Posted by: fathir ali <[hidden email]>
>
>
>

image001.png (11K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] rekap laporan

Sony Ario
In reply to this post by pay
Insya Allah bisa om.

Field tanggal jadiin Values. Settingan nya pake Max. Jangan SUM / COUNT
seperti biasa.




*gnl-excelinfo.blogspot.co.id <http://gnl-excelinfo.blogspot.co.id>*

2018-04-25 16:29 GMT+07:00 fathir ali [hidden email] [belajar-excel]
<[hidden email]>:

>
>
> klo dari pivot bisa nga om
>
> Pada tanggal Rab, 25 Apr 2018 16.26, Sony Ario [hidden email]
> [belajar-excel] <[hidden email]> menulis:
>
>>
>>
>> pakek rumus =Max(C:C) gitu ? bisa gak ?
>>
>> *gnl-excelinfo.blogspot.co.id <http://gnl-excelinfo.blogspot.co.id>*
>>
>> 2018-04-25 14:42 GMT+07:00 fathir ali [hidden email]
>> [belajar-excel] <[hidden email]>:
>>
>>>
>>>
>>> maaf om data salah sy kirimkan lagi
>>> yg di warnai kuning sy mw ambil buat laporan
>>>
>>> Pada 25 April 2018 13.15, 'M.Ade Alfarid' QA@kkmi..co.id <[hidden email]>
>>> [belajar-excel] <[hidden email]> menulis:
>>>
>>>>
>>>>
>>>> Dear,
>>>>
>>>> maksud mw ambil data terbaru itu bagaimana ya?
>>>>
>>>> Mw diambil tujuannya apa? Mw dikemanakan? (mohon maaf gak mudeng….
>>>>
>>>>
>>>>
>>>> Mungkin Jika ingin menampilkan yg terbaru bisa di sort saja, pilih
>>>> sortir tahun,bulan dan tanggal yg diinginkan.
>>>>
>>>> Apakah begini yg diinginkan?
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> Ade
>>>>
>>>>
>>>>
>>>> *From:* belajar-excel@yahoogroups..com <[hidden email]>
>>>> [mailto:[hidden email]]
>>>> *Sent:* Wednesday, April 25, 2018 9:46 AM
>>>> *To:* [hidden email]
>>>> *Subject:* [belajar-excel] rekap laporan [1 Attachment]
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> dear be exceller
>>>>
>>>> saya mw ambil data terbaru berdasarkan tanggal dengan pivot caranya
>>>> gimana ya mohon bimbinganya atas perhatiannya terimakasih
>>>>
>>>> file terlampir
>>>>
>>>>
>>>>
>>>> Posted by: fathir ali <[hidden email]>
>>>>
>>>>
>>>
>>
>

image.png (51K) Download Attachment
pay
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] rekap laporan

pay
alhamdulillah udah bisa om makasih semua nya ya

Pada 25 April 2018 17.55, Sony Ario [hidden email] [belajar-excel] <
[hidden email]> menulis:

>
>
> Insya Allah bisa om.
>
> Field tanggal jadiin Values. Settingan nya pake Max. Jangan SUM / COUNT
> seperti biasa.
>
>
>
>
> *gnl-excelinfo.blogspot.co.id <http://gnl-excelinfo.blogspot.co.id>*
>
> 2018-04-25 16:29 GMT+07:00 fathir ali [hidden email]
> [belajar-excel] <[hidden email]>:
>
>>
>>
>> klo dari pivot bisa nga om
>>
>> Pada tanggal Rab, 25 Apr 2018 16.26, Sony Ario [hidden email]
>> [belajar-excel] <[hidden email]> menulis:
>>
>>>
>>>
>>> pakek rumus =Max(C:C) gitu ? bisa gak ?
>>>
>>> *gnl-excelinfo.blogspot.co.id <http://gnl-excelinfo.blogspot.co.id>*
>>>
>>> 2018-04-25 14:42 GMT+07:00 fathir ali [hidden email]
>>> [belajar-excel] <[hidden email]>:
>>>
>>>>
>>>>
>>>> maaf om data salah sy kirimkan lagi
>>>> yg di warnai kuning sy mw ambil buat laporan
>>>>
>>>> Pada 25 April 2018 13.15, 'M.Ade Alfarid' QA@kkmi..co.id
>>>> <[hidden email]> [belajar-excel] <[hidden email]>
>>>> menulis:
>>>>
>>>>>
>>>>>
>>>>> Dear,
>>>>>
>>>>> maksud mw ambil data terbaru itu bagaimana ya?
>>>>>
>>>>> Mw diambil tujuannya apa? Mw dikemanakan? (mohon maaf gak mudeng….
>>>>>
>>>>>
>>>>>
>>>>> Mungkin Jika ingin menampilkan yg terbaru bisa di sort saja, pilih
>>>>> sortir tahun,bulan dan tanggal yg diinginkan.
>>>>>
>>>>> Apakah begini yg diinginkan?
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> Ade
>>>>>
>>>>>
>>>>>
>>>>> *From:* belajar-excel@yahoogroups..com <[hidden email]>
>>>>> [mailto:[hidden email]]
>>>>> *Sent:* Wednesday, April 25, 2018 9:46 AM
>>>>> *To:* [hidden email]
>>>>> *Subject:* [belajar-excel] rekap laporan [1 Attachment]
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> dear be exceller
>>>>>
>>>>> saya mw ambil data terbaru berdasarkan tanggal dengan pivot caranya
>>>>> gimana ya mohon bimbinganya atas perhatiannya terimakasih
>>>>>
>>>>> file terlampir
>>>>>
>>>>>
>>>>>
>>>>> Posted by: fathir ali <[hidden email]>
>>>>>
>>>>>
>>>>
>>>
>
>

image.png (51K) Download Attachment