S Smitty15 New Member Nov 11, 2010 #1 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?
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?
K keymaster New Member Nov 11, 2010 #2 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.
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.