CODEWITHSUNDEEP
excel
Jovanny
Jovanny

Reputation: 167

Sort numbers using function(s) in Excel

Apart from using the sort function (which is available to only MS 365 subscribers for now), is there a function (or combination of functions) that can be used to return a list of numbers (say 4,5,1,5,3,2,4 in column A) to another column in increasing order?

Upvotes: 1

Views: 55

Answers (1)

basic
basic

Reputation: 11968

Use AGGREGATE:

=AGGREGATE(15,4,$A$1:$A$7,ROW())

enter image description here

Upvotes: 4

Related Questions