GS wrote on 2/25/2011 :
Colin Hayes explained on 2/25/2011 :
Hi

In column F6 - F17 I have a range of formulas giving a range of numeric
results.

Against these I'm trying in column G to have an indication of which of the
cells in F has the highest result , and which the lowest.

Like this

F G

3 Lowest

7

5

11 Highest

9


As the results in F change , so would the noting of highest and lowest.

Grateful for any help with this.

Try this formula in ColG...

=IF(MIN($F:$F)=$F1,"Lowest",IF(MAX($F:$F)=$F1,"Hig hest",""))

Actually, select G6:G17 and revise the formula as follows:

Enter...
=IF(MIN($F:$F)=$F6,"Lowest",IF(MAX($F:$F)=$F6,"Hig hest",""))
Key Ctrl+Enter

You should be able to copy this beyond G6:G17

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc