Solved: Percentage Total
Hello Helpers!
If i have a column, say column A, with 100 rows populated with numbers and my 104th row contains the total(sum) of all the numbers in the above 100 rows. is there a way, that i can automatically populate the adjacent column with a percentage value in regards to the total.
Cheers,
Anupam
Something that has always puzzled me all my life is why, when I am in special need of help, the good deed is usually done by somebody on whom I have no claim. ~William Feather
=A2/$A$104Originally Posted by spartacus132
and format as a percentage.
xld, your suggestion was the quick and dirty method. my example had just 100 rows but there are cases where i have about 4000 rows...and i was wondering if there is a better way than sticking a cell formula in all of those adjacent 4000 rows.
Thanks for the prompt attn. though!
Last edited by spartacus132; 08-18-2006 at 08:32 AM.
Something that has always puzzled me all my life is why, when I am in special need of help, the good deed is usually done by somebody on whom I have no claim. ~William Feather
Better in what way? If you want the percentage of every row, there is no other way that I can see.
Thanks for the prompt attn. though!
Not better, just different
=A1:A4000/A4001 and enter as an array formula.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
Reply With Quote
