SQLDAXExcelPython
LeaderboardRunLifetime
Dynamic arraysHard30 points

Top five by price

Return the five ProductName values (column B of Products) with the highest UnitPrice (column E), highest first.

Hard questions are part of Lifetime and Pro. Read it here, and unlock running and checking your answer from the plans.

How your answer is tested

Your formula goes in a blank sheet. A value or a spilled range both work.

Show solutionLifetime

Runs in your browser with IronCalc, an open-source spreadsheet engine, so this isn't Microsoft Excel. The questions here were checked against real Excel, but a few functions such as AGGREGATE are not available.

Excel formulaselect text to run only that part
Loading editor…

Press Ctrl+Enter or Run to see the result here.