easy5 pts · first answer countsexceldynamic-arrays

Sorting by sales, highest first

A2:B50 holds product names and sales. Which formula returns the table sorted by sales from highest to lowest?

A.=SORT(A2:B50,1,-1)B.=SORT(A2:B50,2,-1)C.=SORT(A2:B50,2,1)D.=SORT(B2:B50,-1,2)

Discussion 0

Join free to post in the discussion.