=IF(B2="buyer";COUNTIFS($B$2:$B$12;"buyer";$A$2:$A$12;">="&A2);"") =IF(B2="seller";COUNTIFS($B$2:$B$12;"seller";$A$2:$A$12;"<="&A2);"")
2016-02-23 14:14 GMT+07:00 'sh.Ronald' sh.ron...@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com>: > > > Selamat siang belajar excel, > Mohon dibantu mengatasi hal dibawah ini : > Value Opt. BUYER SELLER > 22,072,862,500 BUYER 1 > (2,892,702,500) SELLER 1 > 130,387,500 BUYER 6 > 1,734,010,000 BUYER 4 > 2,419,115,000 BUYER 3 > 306,750,000 BUYER 5 > 29,570,000 BUYER 7 > (662,612,500) SELLER 3 > (2,797,850,000) SELLER 2 > 3,167,632,500 BUYER 2 > 2,800,000 BUYER 8 > Bagaimana membuat rumus rangking otomatis pada kolom "Buyer" dan "Seller" > berdasarkan "Value" dari angka terbesar ke terkecil. > > Terima kasih. > > > Ronald > > >
Book1.xlsx
Description: MS-Excel 2007 spreadsheet