Is there a way to get multiple max and mins from a column?

Question

I have to sort some data for a job. I have a script that pulls two columns of data from a larger spreadsheet, then sorts the data by the first column (smallest to largest) then the second column (largest to smallest). I want to so for example I have...

1 29    
1 28    
1 27    
1 24    
2 33    
2 18    
2 17    
3 42    
3 29    
3 19

and I want it to output...

1 29    
1 24    
2 33    
2 17    
3 42    
3 19

What I've been doing is manually deleting these rows so I can then use my next script which does some other manipulation to it. Any way to automatically do this?

Answer 1

While...

• MIN(range) returns the smallest value from range, similarly
• SMALL(range,n) gets the n^th smallest item from range.

...and while...

• MAX(range) returns the largest value from range, similarly
• SMALL(range,n) gets the n^th smallest item from range.

---

Therefore, for example...

• MAX(A1:Z9) is the same as LARGE(A1:Z9,1).

• The 5^th largest value would be LARGE(A1:Z9,5).

---

More information:

Office Support:

• SMALL Worksheet Function
• LARGE Worksheet Function