Hi, I use Excel 2003 and one of the other ways of finding the top and bottom few items in a database in excel would be by using auto filter in the data menu.
Place the cell pointer anywhere in the row where you have the column headers, and go in data menu - filter - auto filter. This puts combo boxes in each cell of the header row. Now go in the desired column in this header row, press Alt + down arrow, and select top 10. It would give a dialog box to select whether you want top or bottom, 10 or different numbers, and you want items or percentages. Press ok to get the filtered result. Copy your result with all other relevant columns and paste it at desired place. To remove the filter again go in the filtered column in the header cell, press alt + down arrow and select 'All'. HTH, best, Pranay. ----- Original Message ----- From: "Aravind Kumar" <aravind_...@yahoo.com> To: <accessindia@accessindia.org.in> Sent: Tuesday, August 28, 2012 7:23 PM 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
