Please help Newbie

  • Thread starter Thread starter Bblatz
  • Start date Start date
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
 
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
 
Back
Top