hardTokopedia · lookupBasic
Top Electronics sellers by sales, filtered and sorted in one formula
Column A holds Tokopedia seller names, column B their category, column C their sales total. Write ONE formula in F2 that returns seller and sales for Electronics sellers only, sorted by sales highest to lowest — no helper columns, and let it spill.
Starting grid
A1
Scroll to see all 7 columns →
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Seller | Category | Sales | ||||
| 2 | Seller A | Electronics | 800 | ||||
| 3 | Seller B | Fashion | 500 | ||||
| 4 | Seller C | Electronics | 1200 | ||||
| 5 | Seller D | Fashion | 300 | ||||
| 6 | Seller E | Electronics | 950 |
Basic
The expected output and walkthrough for this question unlock with a Basic plan.
Basic
The reference formulas and walkthrough for this question unlock with a Basic plan.
See Basic plansRM 25/mo · cancel anytime
Basic
This is a Basic question
Premium practice questions unlock with a Basic plan. The full solution, expected output, and grading are available to Basic members.
RM 25/mo · cancel anytime