http://www.excelbanter.com A Excel forum covering all aspects of Microsoft Excel acting as a web gateway with the finest Micorsoft Excel community newsgroups en Tue, 07 Sep 2010 17:06:58 GMT vBulletin 60 http://www.excelbanter.com/images/002/misc/rss.jpg http://www.excelbanter.com http://www.excelbanter.com/showthread.php?t=265906&goto=newpost Tue, 07 Sep 2010 16:58:17 GMT I'm more of an Access guy than an Excel guy, but I help my coworkers when I can. One of them showed me a worksheet (Excel 2007) that, when you enter a formula in a cell -- e.g., =A2&G2&J2 -- and then try to copy it down a column, behaves strangely. The formula copies down the column, and the cell references appear to have adjusted themselves on each row, but the RESULT is absolutely the same as on the first row. Anybody ever seen that? Is it some obscure setting somewhere? Only way I've found to fix it is to dump the entire worksheet to tab-delimited text, then bring it back into an entirely new workbook. ]]> Excel Discussion (Misc queries) LarryAP http://www.excelbanter.com/showthread.php?t=265906 http://www.excelbanter.com/showthread.php?t=265905&goto=newpost Tue, 07 Sep 2010 15:48:56 GMT Hello, Can anyone help with a macro to delete a row of data if colomn C (date) is before 1/1/2010. I want to anaylize the data from this year olny. I can do... Hello,

Can anyone help with a macro to delete a row of data if colomn C (date) is before 1/1/2010. I want to anaylize the data from this year olny. I can do an auto format to get rid of the info, but the info gets updated every month and all previous data gets dumped back into the file. I need to stream line it so that if anyone else opens the file they only see this years info.

Thanks in advance for the help.

Terry ]]> Excel Worksheet Functions DeFautT http://www.excelbanter.com/showthread.php?t=265905 http://www.excelbanter.com/showthread.php?t=265903&goto=newpost Tue, 07 Sep 2010 12:35:20 GMT Hi needs some help !!!

I am trying to create a very simple formula to calculate the courier shipping charge. " but i am just a nuts and needs help "

i just want the formula to automatically calculate the shipping cost for me each time when i key in the " weight "

The standard formula to calculate the courier shipping charge are in this way.

1) There is a initial minimum charge. first " 0.1kg to 0.5kg " was charge at the price of $24.80. and thereafter for every addintional 0.5kg will be additional charge $5.80 ( Which mean the charger of 1kg is [$24.80 + $5.80= $30.60 )

Any help will be greatly appreciated!

Thanks ! ]]> Excel Worksheet Functions DKTRL http://www.excelbanter.com/showthread.php?t=265903 http://www.excelbanter.com/showthread.php?t=265898&goto=newpost Mon, 06 Sep 2010 09:22:02 GMT I am trying to reflect a better sense of distributing items at a lower level of granularity using constant growth. Here is my example: If I forecast sales in... I am trying to reflect a better sense of distributing items at a lower level of granularity using constant growth.

Here is my example: If I forecast sales in a given year to be 400 units, how do I best distribute those sales among four quarters? The wrong answer is, obviously, 100 units per quarter. Keep in mind that the total sales for the year must still be 400 units.

I suspect that the answer may be quite simple and my brain is moving slow. And I thank you in advance for the advice. ]]> Excel Worksheet Functions JMSprufrock http://www.excelbanter.com/showthread.php?t=265898 http://www.excelbanter.com/showthread.php?t=265893&goto=newpost Sun, 05 Sep 2010 16:53:57 GMT i i am raw (news) here like into additional pepole and building blocks endure a passage period to i i am raw (news) here

like into additional pepole and building blocks

endure a passage period to ]]> About this forum GriepeTield http://www.excelbanter.com/showthread.php?t=265893 http://www.excelbanter.com/showthread.php?t=265892&goto=newpost Sun, 05 Sep 2010 16:53:00 GMT i i am altered (scuttlebutt) here like correct unusual pepole and tools have planned a exit epoch to i i am altered (scuttlebutt) here

like correct unusual pepole and tools

have planned a exit epoch to ]]> Charts and Charting in Excel GriepeTield http://www.excelbanter.com/showthread.php?t=265892 http://www.excelbanter.com/showthread.php?t=265891&goto=newpost Sun, 05 Sep 2010 16:52:04 GMT i i am immature (dirt) here like convene additional pepole and essence be experiencing a gateway improper broad daylight to i i am immature (dirt) here

like convene additional pepole and essence

be experiencing a gateway improper broad daylight to ]]> Charts and Charting in Excel GriepeTield http://www.excelbanter.com/showthread.php?t=265891 http://www.excelbanter.com/showthread.php?t=265890&goto=newpost Sun, 05 Sep 2010 16:51:04 GMT i i am altered (story) here like convene unknown pepole and possessions take in the offing a access day to i i am altered (story) here

like convene unknown pepole and possessions

take in the offing a access day to ]]> Links and Linking in Excel GriepeTield http://www.excelbanter.com/showthread.php?t=265890 http://www.excelbanter.com/showthread.php?t=265889&goto=newpost Sun, 05 Sep 2010 16:50:06 GMT i i am altered (testimony) here like into unknown pepole and stuff have planned a access maturity to i i am altered (testimony) here

like into unknown pepole and stuff

have planned a access maturity to ]]> Excel Worksheet Functions GriepeTield http://www.excelbanter.com/showthread.php?t=265889 http://www.excelbanter.com/showthread.php?t=265888&goto=newpost Sun, 05 Sep 2010 16:49:05 GMT i i am brand-new (biography) here like across into rendezvous with exceptional pepole and flapdoodle procure in the offing a gateway age to i i am brand-new (biography) here

like across into rendezvous with exceptional pepole and flapdoodle

procure in the offing a gateway age to ]]> New Users to Excel GriepeTield http://www.excelbanter.com/showthread.php?t=265888 http://www.excelbanter.com/showthread.php?t=265887&goto=newpost Sun, 05 Sep 2010 16:48:05 GMT i i am altered (the facts) here like into recent pepole and possessions organize a exit duration to i i am altered (the facts) here

like into recent pepole and possessions

organize a exit duration to ]]> Setting up and Configuration of Excel GriepeTield http://www.excelbanter.com/showthread.php?t=265887 http://www.excelbanter.com/showthread.php?t=265886&goto=newpost Sun, 05 Sep 2010 16:47:04 GMT i i am altered (dirt) here like satisfactory additional pepole and tripe be experiencing a access improper daylight to i i am altered (dirt) here

like satisfactory additional pepole and tripe

be experiencing a access improper daylight to ]]> Excel Discussion (Misc queries) GriepeTield http://www.excelbanter.com/showthread.php?t=265886 http://www.excelbanter.com/showthread.php?t=265885&goto=newpost Sun, 05 Sep 2010 16:46:06 GMT i i am artistic (low-down) here like find contemporary pepole and flapdoodle have a exit improper daylight to i i am artistic (low-down) here

like find contemporary pepole and flapdoodle

have a exit improper daylight to ]]> Excel Discussion (Misc queries) GriepeTield http://www.excelbanter.com/showthread.php?t=265885 http://www.excelbanter.com/showthread.php?t=265884&goto=newpost Sun, 05 Sep 2010 16:45:36 GMT i i am altered (biography) here like into unheard-of pepole and flapdoodle take in the offing a barrier period to i i am altered (biography) here

like into unheard-of pepole and flapdoodle

take in the offing a barrier period to ]]> Links and Linking in Excel GriepeTield http://www.excelbanter.com/showthread.php?t=265884 http://www.excelbanter.com/showthread.php?t=265880&goto=newpost Sun, 05 Sep 2010 09:57:45 GMT Hi, im quite new to excel, iv stared selling things and wanted to keep track of my losses and profits, iv made a spreadsheet and so far its ok, any numbers... Hi, im quite new to excel, iv stared selling things and wanted to keep track of my losses and profits, iv made a spreadsheet and so far its ok, any numbers under 0 so with a minus will come up with a red box and if a profit comes then a green box, i have a total profit and total loss box i want all the minus numbers to be added up and tell me all my loss and then all the profit boxes to be added up in the total profit box. i have taken a screenshot and the vales i have used are just for example, thanks for any help. could you explain well please and if so , somthing to copy and paste, much appreciated. Sorry if picture is too big, thanks.

]]> New Users to Excel Austen http://www.excelbanter.com/showthread.php?t=265880