Coba gunakan formula berikut :
=LOOKUP(MAX(B3:B13),B3:B13,C3:C13)
From: ahmad nur ramdani usman <anru_1988@yahoo.co.id>
To: xl mania <XL-mania@yahoogroups.com>
Sent: Friday, October 12, 2012 6:12 PM
Subject: ]] XL-mania [[ Mencari saldo akhir
Dear All Master XL, 
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.
Mohon pencerahannya utk membantu saya agar kerja lebih cepat.
Kondisinya adalah saya ingin merekap saldo akhir tiap bulan yang jumlah barisnya berbeda satu sama lain sesuai dg jumlah transaksi yang ada,
Untuk mengotomatiskannya awalnya saya memakai rumus untuk mencari nilai terkecil, namun tidak semua bulan nilai terkecilnya ada di akhir.
Padahal yang saya inginkan adalah nilai akhirnya. Agar rumus nya dapat dipakai berulang kali, mohon bantuannya rumus apa yang dipakai
Terimakasih atas bantuannya
Salam
Anru.
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.
Nenhum comentário:
Postar um comentário