Thanks for the reply CP but wouldn't that just double each number? the numbers I used were only examples they could be something along the lines of 45 59 78 53 27 I would then need a formula to first of all find the highest number in column a (78) then convert to 100 then multiply all the other numbers by whatever 78 was to change it to 100. so the final numbers would be close to 57 75 100 68 35