Rank Code
 

=RANK(B1,$B$1:$B$14)

and copy down

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Gordon" wrote in message
...
Hi.

Problem:

In column A I have a descending list of 14 tools
In column B I have a % that relates to the tool in column A
In column C I want the position out of 14 in where the value in column B
is
placed.

So if column B3 is the highest value, cell C3 should say 1

Probably a formula solution rathern than VB but any help appreciated.

Thanks

Gordon...