[belajar-excel] Ranking [1 Attachment]
Dear Be-Exceler, Mohon arahannya formula untuk kolom RANK. Yang dirangking berdasar RBM. File terlampir. Salam, DD ranking.xlsx Description: MS-Excel 2007 spreadsheet
Re: [belajar-excel] Ranking [1 Attachment]
=IF(B2="buyer";COUNTIFS($B$2:$B$12;"buyer";$A$2:$A$12;">=");"") =IF(B2="seller";COUNTIFS($B$2:$B$12;"seller";$A$2:$A$12;"<=");"") 2016-02-23 14:14 GMT+07:00 'sh.Ronald' sh.ron...@yahoo.co.id [belajar-excel]: > > > Selamat siang belajar excel, > Mohon dibantu