Dear : Aa Nyontek dari ilmu para suhu : =IF((SUMPRODUCT(MAX(($B$5:D7=B8)*($D$5:D7)))+0,1)<B8;B8+0,1;SUMPRODUCT(MAX(($B$5:D7=B8)*($D$5:D7)))+0,1) atau =IF((MAX(INDEX(($B$5:B7=B8)*$D$5:D7;0))+0,1)<B8;B8+0,1;(MAX(INDEX(($B$5:B7=B8)*$D$5:D7;0))+0,1)) semoga membantu Piet
________________________________ Dari: ahmad <[email protected]> Kepada: [email protected] Dikirim: Rabu, 8 Agustus 2012 7:55 Judul: ]] XL-mania [[ manambahka angka dibelakang secara otomatis Dear All, Mohon pencerahannya seperti data dibawah ini Terimakasih. Salam hormat, Aa Information provided in this email, including any attachments, is intended for the addressee named and deemed confidential property of PT. Tanabe Indonesia. Any use of information provided herein, including but not limited to the registered PT. Tanabe Indonesia name and logo are prohibited without the written permission of PT. Tanabe Indonesia. If you are not the intended recipient, any use, printing, copying or distribution of this e-mail or of any attachments to it is strictly prohibited. If you received this e-mail in error, please advise the sender immediately and delete the e-mail and any attachments from your system. Thank you.
Max Max.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
