Home 
Search 
Today's Posts 
#1




Want a percentages of a single cell divided by a column of cells
Want the symbol to make the formula repeat in each new cell, but keep the
second cell the same. Thought it was a karat, but that doesn't work. 
#2




Want a percentages of a single cell divided by a column of cells
Hazarding a guess that
the dollar sign ($) is what you're after here Maybe you mean something like this: You've got numbers in A1:A9, with the total in A10 [ in A10: =SUM(A1:A9) ] Then in B1: =A1/A$10 B1 is formatted as percentage, and copied down to B10 to return the corresponding percentages The $ sign in A$10 will fix it to the row10 where the total cell is in col A. Hence this part won't change when B1 is copied down.  Max Singapore http://savefile.com/projects/236895 xdemechanik  "dbog" wrote in message ... Want the symbol to make the formula repeat in each new cell, but keep the second cell the same. Thought it was a karat, but that doesn't work. 
#3




Want a percentages of a single cell divided by a column of cells
You need to make the cell reference for the second cell absolute  you
use the dollar symbol $ for this, for example: =A2/A$1 When you copy this down it will become: =A3/A$1 =A4/A$1 etc. Hope this helps. Pete dbog wrote: Want the symbol to make the formula repeat in each new cell, but keep the second cell the same. Thought it was a karat, but that doesn't work. 
#4




Want a percentages of a single cell divided by a column of cel
Yes, that's it!! Thanks to both of you so much. It saves me a ton of
copying and pasting. "Max" wrote: Hazarding a guess that the dollar sign ($) is what you're after here Maybe you mean something like this: You've got numbers in A1:A9, with the total in A10 [ in A10: =SUM(A1:A9) ] Then in B1: =A1/A$10 B1 is formatted as percentage, and copied down to B10 to return the corresponding percentages The $ sign in A$10 will fix it to the row10 where the total cell is in col A. Hence this part won't change when B1 is copied down.  Max Singapore http://savefile.com/projects/236895 xdemechanik  "dbog" wrote in message ... Want the symbol to make the formula repeat in each new cell, but keep the second cell the same. Thought it was a karat, but that doesn't work. 
#5




Want a percentages of a single cell divided by a column of cel
You're welcome !
Thanks for feeding back to us ..  Max Singapore http://savefile.com/projects/236895 xdemechanik  "dbog" wrote in message ... Yes, that's it!! Thanks to both of you so much. It saves me a ton of copying and pasting. 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
VBA: For Count, when count changes from cell to cell  Excel Discussion (Misc queries)  
How do I combine spreadsheets and documents in one file?  Excel Discussion (Misc queries)  
Copying a column of single cells into a column of merged cells  Excel Discussion (Misc queries)  
Custom functions calculating time arguments Help Desperate  Excel Worksheet Functions  
Possible Lookup Table  Excel Worksheet Functions 