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 | | | | | | | |