Top 15 on another sheet

[LeeBillington]

Hey guys,

Quick question.

How would i go about getting a top 15 numbers from sheet 'pickrate' back to 'sheet1' for example

So the numbers are in sheet 'Pickrates' between k6:k1000

but also how could i also get the name allocated to them top numbers in a different column? the names are in B6:B1000

both returning back to 'sheet1' from pickrate.

 

[LeeBillington]

Still doing the same, the start of the error has turned into "=_xlnf.IFERROR

 

[Eric W]

You said the problem was with INDEX, but it appears that it is with the IFERROR. IFERROR has only been available since 2007, so that is probably your problem. You'll either have to remove the IFERROR part of your formula, and accept the error from it, or use ISERROR like Mark showed in post #14. That doubles the size of the formula (which is why IFERROR was added later).

 

[LeeBillington]

So it will work if i take the error out? most of the time there will be data.. but its just a cosmetic thing really

 

[Eric W]

It should. Try it and let us know.