Sort numbers using function(s) in Excel

Question

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?

basic · Accepted Answer · 2020-08-24 23:59:40Z

4

Use AGGREGATE:

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

answered Aug 24, 2020 at 23:59

basic

12k2 gold badges15 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Jovanny Over a year ago

Thanks a lot, although, I used the small function directly.

not2qubit Over a year ago

Would have been nice to have short explanation of what the aggregate function does, and it's arguments. I.e. What does the 15;4 do?

basic Over a year ago

@not2qubit 15 means function type SMALL and 4 means option Ignore nothing, so AGGREGATE returns k smallest value from range A1:A7.

Collectives™ on Stack Overflow

Sort numbers using function(s) in Excel

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related