Cross-referencing from columns that havent been sorted

[Chris Norton]

Hi all

A quickie - when I am looking at Sheet 1, Column A, and I want the ten highest (And unsorted) values in A to be listed in Sheet 2, what formula do I use?

Many thanks in advance

Chris

 

[Juan Pablo González]

LARGE is the function you're looking for.

 

[Chris Norton]

Hi Juan Pablo

Many thanks for your reply sir.

Right........how do I do it?! Apologies, I am a simple man!

Thanks again

Chris