I assume you mean your names are in A3 to A220 and their absences are in P2
to P220 on the sheet Sick List.

Paste this anywhere on your sheet Top Ten and drag down 10 cells.

=INDEX('Sick History'!A$3:A$220,MATCH(LARGE('Sick
History'!P$3:P$220,ROW(A1)),'Sick History'!P$3:P$220,0))

Mike

"louiscourtney" wrote:

Mike
Thanks for the reply
Sorry but I'm quite a novice
The data i want to extract from a tab called "sick history" is in columns A3
down to A220 and then P3 down to P220 and then to auotmatically place it in a
new tab called Top 10 and then sort it in order highest first

Is there away to do this??

"Mike H" wrote:

Hi,

Using large with your date liad out like this:-
Col A Col B
Name 1 23
Name 2 56
Name 3 33
Name 4 44
Name 5 11
Name 6 88

Put this formula on your sheet and drag down as far as you want. Change the
ranges as required.

=INDEX(A$1:A$100,MATCH(LARGE(B$1:B$100,ROW(A1)),B$ 1:B$100,0))

Mike

"louiscourtney" wrote:

Sorry to be rude but how do i do that?

"bj" wrote:

the rank() or large() function would identify the top ten people
then on your new sheet an index match woul dpull the top ten over.

"louiscourtney" wrote:

I would like to be able to set up an extra tab in my worksheet that gives me
the top 10 performers
I can't use the normal filter sort as not all the cells are the same size
and it all goes out of sync

The sheet where the information is held is layed out as follows
Column A has all the names from A3 down to A220
then there is various other columns with other data until we get to column P
which has totals in it

Column P3 down to P220

What i would like is some sort of caluculation that picks up the name then
the corresphonding amount and then sorts it into the top 10 perfromers

And then enters the information on the seperate tab

Any help would be appreciated