Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Formula for sorting multiple columns

0

I need a formula to sort 2k columns with only 4 numbers in each column from lowest to highest.

Answer
Discuss

Answers

0

You might use the SMALL() function for that. Say, your 4 numbers are in A2:A5. Enter the formula below in A8 and copy down to A11.

=SMALL(A$2:A$5,ROW()-7)

The 7 in the formula points at the row above the row in which you write the first formula. If you were to write to A10 that number must be 9.

You can copy the formula across to other columns as needed.

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login