Mungkin ini yang dimaksud.. (See attached file: rumus bulan rev1.xlsx) Terimakasih
Regards,
Riska
From: Aden S <[email protected]>
To: "[email protected]" <[email protected]>
Date: 08/01/2013 08:20 AM
Subject: Re: [belajar-excel] Rumus bulan
Sent by: [email protected]
1. wed 10/9/13 itu diganti hanya 10/9/13
2. yang ingin dicari di F6 adalah range antara bulan di D6 sampai di E6
masuk di kategori G3 sampai I3 sehingga jika rumusnya sudah dapat, di F7
dst mengikuti rumus yang di F6.
Terlampir lampiran yang baru
Terima kasih atas bantuannya
Salam
Aden
From: Mr. Kid <[email protected]>
To: BeExcel <[email protected]>
Sent: Thursday, August 1, 2013 3:15 AM
Subject: Re: [belajar-excel] Rumus bulan
Bolehkah lebih dijelaskan lagi arti dari :
1. Wed 10/9/13 itu nilai data yang menunjukkan apa ?
2. Yang ingin dibuat itu seri waktu yang harinya sama (Wed) di bulan G3
atau tanggal yang sama (10) unbulan G3 ?
Wassalam,
Kid.
2013/7/31 Aden S <[email protected]>
Dear para Exceller,
Mohon bantuannya untuk membuat rumus bulan dimana yang "tanda tanya"
jawabannya harus oct-13, karena yang akan dicari wed 10/9/13 dan
10/11/13 masih termasuk didalam bulan oct-13, untuk lebih detailnya
saya lampirkan file excel.
Terima kasih atas bantuannya
Salam hangat
Aden
|--------+--------+--------+-----------+-------------+-----------+---------+--------+--------+--------+--------+--------+--------+--------+-------->
| | | | | | | |
| | | | | | | |
|--------+--------+--------+-----------+-------------+-----------+---------+--------+--------+--------+--------+--------+--------+--------+-------->
>--------+--------|
| | |
>--------+--------|
|--------+--------+--------+-----------+-------------+-----------+---------+--------+--------+--------+--------+--------+--------+--------+-------->
| | | | | | | |
| | | | | | | |
|--------+--------+--------+-----------+-------------+-----------+---------+--------+--------+--------+--------+--------+--------+--------+-------->
>--------+--------|
| | |
>--------+--------|
|--------+--------+--------+-----------+-------------+-----------+---------+--------+--------+--------+--------+--------+--------+--------+-------->
| | | | | | |Oct-13 |
| | | | | | | |
|--------+--------+--------+-----------+-------------+-----------+---------+--------+--------+--------+--------+--------+--------+--------+-------->
>--------+--------|
| | |
>--------+--------|
|--------+--------+--------+-----------+-------------+-----------+---------+--------+--------+--------+--------+--------+--------+--------+-------->
| | | | | | | |
| | | | | | | |
|--------+--------+--------+-----------+-------------+-----------+---------+--------+--------+--------+--------+--------+--------+--------+-------->
>--------+--------|
| | |
>--------+--------|
|--------+--------+--------+-----------+-------------+-----------+---------+--------+--------+--------+--------+--------+--------+--------+-------->
| | | | | | | |
| | | | | | | |
|--------+--------+--------+-----------+-------------+-----------+---------+--------+--------+--------+--------+--------+--------+--------+-------->
>--------+--------|
| | |
>--------+--------|
|--------+--------+--------+-----------+-------------+-----------+---------+--------+--------+--------+--------+--------+--------+--------+-------->
| | | | Wed | Wed 10/11/13|?? |=======>
|Oct-13 | | | | | | | |
| | | |10/9/13 | | | |
| | | | | | | |
|--------+--------+--------+-----------+-------------+-----------+---------+--------+--------+--------+--------+--------+--------+--------+-------->
>--------+--------|
| | |
>--------+--------|
|--------+--------+--------+-----------+-------------+-----------+---------+--------+--------+--------+--------+--------+--------+--------+-------->
| | | | | | | |
| | | | | | | |
|--------+--------+--------+-----------+-------------+-----------+---------+--------+--------+--------+--------+--------+--------+--------+-------->
>--------+--------|
| | |
>--------+--------|
|--------+--------+--------+-----------+-------------+-----------+---------+--------+--------+--------+--------+--------+--------+--------+-------->
| | | | |Pertanyaannya| | |
| | | | | | | |
| | | | | : bagaimana | | |
| | | | | | | |
| | | | |rumus membuat| | |
| | | | | | | |
| | | | |kolom F6 | | |
| | | | | | | |
| | | | |dengan hasil | | |
| | | | | | | |
| | | | |seperti I6, | | |
| | | | | | | |
| | | | |karena kolom | | |
| | | | | | | |
| | | | |D6 dan D7 | | |
| | | | | | | |
| | | | |masih masuk | | |
| | | | | | | |
| | | | |dalam bulan | | |
| | | | | | | |
| | | | |G3? | | |
| | | | | | | |
|--------+--------+--------+-----------+-------------+-----------+---------+--------+--------+--------+--------+--------+--------+--------+-------->
>--------+--------|
| | |
>--------+--------|
|--------+--------+--------+-----------+-------------+-----------+---------+--------+--------+--------+--------+--------+--------+--------+-------->
| | | | | | | |
| | | | | | | |
|--------+--------+--------+-----------+-------------+-----------+---------+--------+--------+--------+--------+--------+--------+--------+-------->
>--------+--------|
| | |
>--------+--------|
|--------+--------+--------+-----------+-------------+-----------+---------+--------+--------+--------+--------+--------+--------+--------+-------->
| | | | | | | |
| | | | | | | |
|--------+--------+--------+-----------+-------------+-----------+---------+--------+--------+--------+--------+--------+--------+--------+-------->
>--------+--------|
| | |
>--------+--------|
|--------+--------+--------+-----------+-------------+-----------+---------+--------+--------+--------+--------+--------+--------+--------+-------->
| | | | | | | |
| | | | | | | |
|--------+--------+--------+-----------+-------------+-----------+---------+--------+--------+--------+--------+--------+--------+--------+-------->
>--------+--------|
| | |
>--------+--------|
[attachment "rumus bulan rev1.xlsx" deleted by Riska Wahyu
Nirmalasari/AQUA/ID/BO/DANONE]
Ce message électronique et tous les fichiers attachés qu'il contient sont
confidentiels et destinés exclusivement à l'usage de la personne à laquelle ils
sont adressés. Si vous avez reçu ce message par erreur, merci de le retourner à
son émetteur. Les idées et opinions présentées dans ce message sont celles de
son auteur, et ne représentent pas nécessairement celles de DANONE ou d'une
quelconque de ses filiales. La publication, l'usage, la distribution,
l'impression ou la copie non autorisée de ce message et des attachements qu'il
contient sont strictement interdits.
This e-mail and any files transmitted with it are confidential and intended
solely for the use of the individual to whom it is addressed. If you have
received this email in error please send it back to the person that sent it to
you. Any views or opinions presented are solely those of its author and do not
necessarily represent those of DANONE or any of its subsidiary companies.
Unauthorized publication, use, dissemination, forwarding, printing or copying
of this email and its associated attachments is strictly prohibited.
rumus bulan rev1.xlsx
Description: Binary data
