Excel Help Needed - Coin Community Forum

To participate in the forum you must log in or register.

Author	Replies: 6 / Views: 2,690
akglen Valued Member United States 170 Posts	Posted 03/28/2011 3:48 pm Hi, I am having a problem with a simple copy command. I use excel to catalog my coins. I've I have a column in which I list the ASW and another which lists the value of the coin for it's bullion value. I have no problem with either using copy and paste or auto fill to put the ASW value into it's column. My problem is that when I copy and paste or auto fill the column with the formula, it always changes the cell number which in which I have the current silver spot. An example of a cell I copy is; =SUM(J100K1) when I paste it I get; =SUM(J101K2). No matter what I do I cannot get the formula to maintain a constant of K1. Can anyone help with this? It sure would make things easier then going into each cell and changing to the constant of K1! Report this Post to the Staff

gormang Valued Member United States 182 Posts	Posted 03/28/2011 3:52 pm use $K$1, that will always refer to k1, whenever you don't use the dollar sign it is a relative location. you can also do stuff like $K1, or K$1 to make the row or column constant and the other relative Report this Post to the Staff
akglen Valued Member United States 170 Posts	Posted 03/28/2011 4:02 pm gormang; I can't tell you how much of a help you have been! You have without a doubt saved me hours of the worse kind of drudge work! Thanks Glen Report this Post to the Staff
gormang Valued Member United States 182 Posts	Posted 03/28/2011 4:27 pm Glen, no problem, glad I could help Excel is extremely useful and powerful, there are so many things you can do with it. but sometimes getting it to do the simplest can be frustrating. I also use excel to catalog my collection, as do many others. my spreadsheet is in a perpetual state of evolution. I have 40+ tabs, one each for my albums and assorted other stuff. and I'm in the process now of importing all of numismedia's coin values so that I have a dynamic valuation of my collection based on type, year, and grade. If you need any help with anything else let me know. Report this Post to the Staff
Wheatbackfever New Member United States 7 Posts	Posted 03/31/2011 9:21 pm I just made up some penny roll listings with Excel. It's nice to have a protective feature on it, and the use of formulas make computations easy. Report this Post to the Staff
kc_hhsl New Member United States 25 Posts	Posted 05/19/2011 11:26 pm Why do you use the formula: =sum(j100k1) Would you get the same answer if you used: =j100k1 KC Report this Post to the Staff
Spikey Norman Valued Member Ireland 131 Posts	Posted 05/20/2011 06:11 am Yep, using SUM for just one value is not only pointless but increases the size of the spreadsheet on disk and if done enough times will also slow the s/s down. Just j100*$k$1 would be fine. Norm Report this Post to the Staff
	Replies: 6 / Views: 2,690

To participate in the forum you must log in or register.

All Forums Category: General Numismatic Forums Forum: Supplies, Books, Reference, Software, etc

Silver Gold Bull US is the United States leading bullion dealer. We deliver gold coins, gold bars, silver coins, silver bars and precious metals to your door. Order today!

The First Dollar, your premier source for bullion and rare coins. See our bullion list on the site and the coin inventory on ebay.

Disclaimer: While a tremendous amount of effort goes into ensuring the accuracy of the information contained in this site, Coin Community assumes no liability for errors. Copyright 2005 - 2026 Coin Community Family- all rights reserved worldwide. Use of any images or content on this website without prior written permission of Coin Community or the original lender is strictly prohibited.
Contact Us | Advertise Here | Privacy Policy / Terms of Use

Coin Community Forum

It took 0.27 seconds to rattle this change.