Hello,

This is a continuation of a recent problem I had. But never mind that
for now:)

I essentially have a range of data which has been ranked from largest
to smallest and according to various criteria. I would now like to
return those results which are ranked highest until a certain point -
example; my workbook tells me I need to know the top 15 results. I
would like to return the 1st, 2nd, 3rd and so on results until the
15th, or whichever number that happens to be.

I envision something that can return the number one ranked result as
long as it is less than the cell which contains the limit (15), and
copying that down with modification so that it brings over the 2nd, 3rd
etc.

Thanks.