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