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?
LARGE function: How to create with nested function?(2 posts) (2 voices)
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.
b1:b10 have numbers <100, A1:a10 have whole numbers, no fractions.
You must log in to post.