"vezerid" wrote:

OK, I got it. I tried to do it without an auxiliary column but it is
too late and it is not working, so quickly you will have to settle for
an extra column next to the data. This formula, starting at G2:

=IF(ISNUMBER(MATCH(F2,$C$2:$C$8,0)),INDEX($A$2:$A$ 8,MATCH(F2,$C$2:$C$8,0))-D2,"")

It will leave either a blank or the difference of the rank of a name
(rank1-rank2). I.e. you are driven by Name2 as I understand from all
your posts. Copy this formula as far down as necessary. Then:

Unconditional Max/min:
=MAX(G2:G8) =MIN(G2:G8)

Conditional Max/min (ARRAY formula)
=MAX(IF(E2:E824,G2:G8)) =MIN(IF(E2:E824,G2:G8))

and
=MAX(IF(E2:E8<=24,G2:G8)) =MIN(IF(E2:E8<=24,G2:G8))

Array formulas must be committed with Shift+Ctrl+Enter

I will be going now, so I will revisit the thread in the morning. I
will see if I can find a solution without using the extra column, but
it seems we have hit something sticky here.

HTH
Kostis

Thanks Kostis works perfectly. Only thing that would be handy is there a way
for the results (4 values) could be linked or to return the corresponding
name in column 6? It just saves time scrolling to find the corresponding name
for the particular values. Perhaps highlight the name or something. Thanks
again.

M