
1. Re: function for 2nd, 3rd, ..., nth largest/smallest value in a column
sirajmandayippurath Sep 14, 2012 1:50 PM (in response to Nay Lin Soe)Hi Nay,
I don't think there is a function that gives you this straight off. Probably you could find the nth largest number using the Index() function?
Regards
Siraj

2. Re: function for 2nd, 3rd, ..., nth largest/smallest value in a column
Nay Lin Soe Sep 16, 2012 4:07 PM (in response to sirajmandayippurath)Hi Siraj,
Thanks for responding. Index() function, as far as I know, returns the positional value of a row in a table, regardless of its content. Could it really help in ranking values?
Nay

3. Re: function for 2nd, 3rd, ..., nth largest/smallest value in a column
sirajmandayippurath Sep 16, 2012 11:12 PM (in response to Nay Lin Soe)Hi Nay,
Yes, you could use it to find the position in a set as long as you order the set (sort) it in the way you want.
Cheers
Siraj

4. Re: function for 2nd, 3rd, ..., nth largest/smallest value in a column
sirajmandayippurath Sep 17, 2012 1:19 AM (in response to sirajmandayippurath)1 of 1 people found this helpfulHi Nay,
I have attached a workbook with an example for your reference. Hope it helps.
Cheers
Siraj

5. Re: function for 2nd, 3rd, ..., nth largest/smallest value in a column
Nay Lin Soe Sep 17, 2012 10:10 PM (in response to sirajmandayippurath)Hi Siraj,
Thank you for attempting this for me. I've looked at what you have attached. It works on the precondition that the table is sorted, at design time, according to Sales column. I suppose there is no direct way to find, say, the 2nd largest sales value if there is NO guarantee that the column is sorted (which is my case)?
Nay

6. Re: function for 2nd, 3rd, ..., nth largest/smallest value in a column
kettan Sep 20, 2012 4:33 AM (in response to Nay Lin Soe)Independent Ranking
Ranking can be calculated even if table at design time is not sorted. Example below is silly in production, but does show that ranking can be independent of sorting used in table:Filter Individual Rankings
If you what you meant was to filter only the 2nd to for example 10th in rank of sales, this can be done with a quick filter as seen below: 
7. Re: function for 2nd, 3rd, ..., nth largest/smallest value in a column
Nay Lin Soe Sep 23, 2012 7:41 PM (in response to kettan)Excellent! Thank you for your help.