I am attempting to retrieve a list of the ten smallest numbers in a list of about 70 (in which there are duplicates, and i need the duplicates listed) and then use the INDEX function to copy the data beside these ten numbers and put it beside the list that i have created, beside it's corresponding number (even put the correct data beside each duplicate number, in order, as they have different data beside each of them). I have managed to get a list of the ten smallest numbers (Including duplicates) by using the following formula in a column of ten cells
=SMALL(CHOOSE(1,A1:A70),1)
=SMALL(CHOOSE(1,A1:A70),2)
=SMALL(CHOOSE(1,A1:A70),3)
etc...
however when i attempt to use the above formula as a row number in an INDEX function, it will not work.
Any help much appreciated!
Bookmarks