Please help Newbie

B

Bblatz

Hello,

I have a column of numbers and I need the function (in the column beside it)
to find the lowest number and then divide that number into each value of the
column and mulitply by 100 to obtain the percentage. Any help is appreciated.

BB
 
P

Pete_UK

Try this in B1, assuming your numbers are in the range A1:A100:

=A1 / MIN(A$1:A$100)

Format the cell as percentage, and then copy down.

Hope this helps.

Pete
 
Top