Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 4th 07, 10:57 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 2
Default 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   Report Post  
Old January 4th 07, 11:07 PM posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 9,221
Default 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   Report Post  
Old January 4th 07, 11:09 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 8,856
Default 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   Report Post  
Old January 5th 07, 04:45 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 2
Default 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   Report Post  
Old January 5th 07, 11:37 PM posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 9,221
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA: For Count, when count changes from cell to cell LenS Excel Discussion (Misc queries) 18 January 4th 07 12:53 AM
How do I combine spreadsheets and documents in one file? Trish Excel Discussion (Misc queries) 3 November 9th 06 09:17 PM
Copying a column of single cells into a column of merged cells [email protected] Excel Discussion (Misc queries) 1 August 16th 06 01:18 PM
Custom functions calculating time arguments Help Desperate Bill_De Excel Worksheet Functions 12 April 25th 06 02:22 AM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM


All times are GMT +1. The time now is 11:36 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017