Use the Large() function of Excel. For example, the below formula returns the 3rd largest number in the cell range A1:A10.
=LARGE(A1:A10, 3) To get the 4th largest value in the cell range B1:B100, type the below formula: =LARGE(B1:B100, 4) The Small() function returns the specified smallest number in the given array. For example, the below formula returns the 7th smallest value in the range P201:P500. =SMALL(P201:P500, 7) Let me know if this helps or if you need more inputs. On 8/27/12, Aravind Kumar <aravind_...@yahoo.com> wrote: > hai friends, as subject says, i have a doubt in excel in sorting. > in my bank, in chennai zone, there are 86 branches. we have to prepare a > report showing top5 performers in deposits advances etc. > if we sort manually, it will happen. but among 86 branches, there are > divisions like new branches, AGM branches etc which i should not disturb the > order. > so i have to create a separate list showing top5 performers with maximum > number. > so kindly anybody suggest me how to identify top5 big numbers using > formulas? i know we can use max function for getting topmost number. but i > want second third fourth and fifth also. if we use rank function, it will > return the actual rank only not the actual number or related amount. so > please suggest me a good way. > > regards. > > aravind. > > > Search for old postings at: > http://www.mail-archive.com/accessindia@accessindia.org.in/ > > To unsubscribe send a message to > accessindia-requ...@accessindia.org.in > with the subject unsubscribe. > > To change your subscription to digest mode or make any other changes, please > visit the list home page at > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > -- Best Regards, Zujar... An optimist laughs to forget, whereas a pessimist forgets to laugh! Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in