Hi. Wasn't sure where to post this. I have a row of data (let's say Row A), how can I get the highest value of the row to show as 100% (In Row B) and each number below it to be a percentage of that 100%?
Edit: Sorry. I forgot to state that the highest value is going to be a different number each time this spreadsheet is going to be used
Edit: Sorry. I forgot to state that the highest value is going to be a different number each time this spreadsheet is going to be used
Last edited: