rumusnya berupa array formula ="Sales Best Performance: "& INDEX($B$1:$B$8;MAX((MAX(TABLE)=TABLE)*ROW($C$4:$G$8)))& " dari Cabang "& INDEX($A$3:$G$3;MAX((MAX(TABLE)=TABLE)*COLUMN($C$4:$G$8)))
*On Wed, Mar 28, 2012 at 12:45 AM, Santoso <[email protected]> wrote: * > > * * > *Dear XL-mania, > Mohon bantuannya cara menentukan nama baris dan nama kolom untuk nilai > maksimal dalam 1 array* > *(terlampir di attachment)* > *Terima kasih banyak ya ... > Best Regards,* > *Santoso > * >
Sales Best Performance (Array Formula - Rr_Wilis).xls
Description: MS-Excel spreadsheet
