Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

dengar169

macrumors member
Original poster
Sep 20, 2007
98
0
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
 
Last edited:
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.