this can be achieved with the Lookup() function of Excel. Here's a formula to get the branch name for the top depositor in the example you specified:
=Lookup(Large(J3:J91, 1), J3:J91, B3:B91) -- Regards, Zujar... An optimist laughs to forget, whereas a pessimist forgets to laugh! -----Original Message----- From: accessindia-boun...@accessindia.org.in [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Aravind Kumar Sent: Tuesday, August 28, 2012 7:24 PM To: accessindia@accessindia.org.in Subject: Re: [AI] new doubt in excel thank you friend, the large and small functions are working and almost satisfied my requirement. another problem i'm having. with large, i'm able to find best 5 performing branches with datas available from j3 to j91. now, i have to display the related branch names also which are available from b3 to b91. so, for example, if top performing branch is in j38 with largest number and if i need to display the related branch's name available in b38, how to relate with formula and display? due to this problem, i'm manually searching and copying which consumes a lot of time. so please help me. 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 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
