hI ALL!
In column A there are names, in B - corresponding values. I need the 10 largest and the 10 smallest values and names. I thought of using =small and =large functions but then how can i find the corresponding names? the problem arises when the largest 3,4 an5th values are all 1.00 then match/index is useless to find the corresponding names.
Any ideas how to overcome the problem or alternative solutions will be welcome. thanks in advance
hi Alexander_Golinsky, see if the attached file can help you.
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Thank you a lot, benishiryo!! It does look like doing the job. Can i ask you a questions? if i convert it into classical (A1) style reference will it work? i'm pretty sure it will, but still it's rare to see using of RC style, maybe there is particular reason linked to the solution..
---------- Post added at 07:52 AM ---------- Previous post was at 07:45 AM ----------
A lot of thanks!! Solved
Last edited by Alexander_Golinsky; 07-27-2012 at 08:48 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks