It's going to help me for sure, zujarji thanks
On 8/27/12, Zujar Shabbir Kanchwala <zujarbri...@gmail.com> wrote: > 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 > > -- “The waves breaking on the surface draw all the attention, but it is the current beneath the water that determines your direction.” 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