Could someone please help with a formula please? I want to find the highest value in a column and convert that figure to 100 and then have all the other numbers in that column converted in proportion to the first figure if you get my drift. For example if column a has numbers 20 50 30 10 then i would like the 50 to change to 100 and then have the others convert by the same percentage so that the new figures would read 40 100 60 20 hope I've made it clear enough. thanks in advance.