1. 

   Smitty15
   

   Member
   Joined: Nov '10
   Posts: 18

   I would like to sort a column based on numberical values, but then further sort them based on an asigned unique number from another column. How can I write this into a LARGE function equation?

   Posted 2 years ago #
2. 

   Chandoo
   

   Key Master
   Joined: Jul '09
   Posts: 587

   Assuming you have values in A1:A10 and unique numbers in B1:B10, you can try this approach:

   =large(($a$1:$a$10)+($b$1:$b$10)/100,1) gives you 1st number in sorted order.

   Assumptions:

   b1:b10 have numbers <100, A1:a10 have whole numbers, no fractions.

   Posted 2 years ago #

RSS feed for this topic

Reply

You must log in to post.

Welcome to Chandoo.org. New here?

Thank you so much for visiting us & taking first step to become awesome in Excel. Please use below links to navigate our site.

Learn Excel - Topics » Excel for Beginners - Tutorials » Excel Formula Examples » Array Formulas » Excel Charts » Pivot Tables » Project Management using Excel » Excel Dashboards » Excel VBA » Advanced Excel

Our Products Full Training Programs » Excel School » Excel Dashboard Classes » Excel VBA Classes » Excel Financial Modeling » Excel for PMs Crash Courses » Excel Formula Course » Excel Dashboards Course Downloads » Excel PM Templates » Excel Formula E-book

About us » About Chandoo.org » Welcome » Best of Chandoo.org » FREE Excel Downloads » Contact Details » Excel Forums