A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners


Popular Tags: Excel Worksheet Functions
, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

Post New Thread
Threads in Forum : Excel Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Red face
Go to first new post Needs Help "calculate of courier service charge" by DKTRL
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...
Today 05:47 PM
by DeFautT Go to last post
1 19
delete row macro by DeFautT
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...
Today 04:48 PM
by DeFautT Go to last post
0 7
Distribution calculation by JMSprufrock
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...
Yesterday 10:22 AM
by JMSprufrock Go to last post
0 21
kabbalah by GriepeTield
i i am altered (testimony) here like into unknown pepole and stuff have planned a access maturity to
September 5th 10 05:50 PM
by GriepeTield Go to last post
0 26
Help with formula trowing a #value! result by axelman
Hi I've downloaded a mortgage calculator from the web, being anewbie I'm stuck with the following issue: When the last payment comes down to 0 or near 0...
(Multi-page thread 1 2)
August 31st 10 11:30 AM
by global_property Go to last post
11 131
Unhappy
Update dates annually by Misty Sunshine
I need to have excel calculate a formula each month from a stationary date which I can do with =date however at the beginning of each new year I need the...
August 31st 10 10:56 AM
by wickedchew Go to last post
2 86
Negative fraction power by renzouken
Hi! Can anyone help me how to properly apply this function =(2/3)*(B2)*(B2^(-2/3)), where B2=-1 I tried this =((2/3)*(B2))*(SIGN(B2)^(-2/3)), but not...
August 29th 10 01:05 PM
by renzouken Go to last post
2 92
How can I stop format change when copying data into unlocked cells by Linty
How can I stop the format changing when I copy data into an unlocked cell in a format protected worksheet? I need to allow people to both enter data or copy...
August 27th 10 09:46 PM
by kmroy0320 Go to last post
2 169
2 Attachment(s) Complex Sumif Formula by Lorax
I am creating a weld mapping tool for work that tracks welding errors. I am trying to sum the total errors for any given company ("a", "b", "c", etc.). The...
August 25th 10 11:36 AM
by Lorax Go to last post
7 153
1 Attachment(s) SumIf/IfStatements: Referencing more them one attribute by gaznev2000
Hi all, just wondering if any one can help with my If statement dilemma. I'm creating a stock tracking excel for my company and have run into a issues when...
August 25th 10 10:19 AM
by wickedchew Go to last post
1 74
Question
Can the MATCH function search across several worksheets? by michellep
I'm on Excel 2003, Windows XP. No VBA, please (beyond my and my co-worker's capabilities). I have a MATCH function that is working successfully like...
August 25th 10 03:33 AM
by wickedchew Go to last post
1 78
Question
Can the MATCH function search across several worksheets? by michellep
I'm on Excel 2003, Windows XP. No VBA, please (beyond my and my co-worker's capabilities). I have a MATCH function that is working successfully like...
August 25th 10 01:02 AM
by michellep Go to last post
0 60
total sum of objects with the same name by Iggawalla
Hello, I am trying to create a spreadsheet that will contain information regarding vehicles and the price in which I sold them for. e.g. Column A:...
August 25th 10 12:13 AM
by wickedchew Go to last post
2 121
Hello, fresh here! by HardenMassie
I'm a beginner to this community forum. I hope you guys help me always if I fall in trouble. And I'm really happy to join with you. Pls share your valuable...
August 24th 10 10:13 PM
by HardenMassie Go to last post
0 55
Counting the Number of Consecutive Ranges by allan2005CL
I need to create a formla that counts the number of times certain text will appear in a row. For example in cells A1 - J1 there could be following: A1 = S, B1...
August 22nd 10 08:46 PM
by allan2005CL Go to last post
0 73
Macro for populating spreadsheet with formulas by johannes2008
Hello All What I am trying to do is create a macro that populates a spreadsheet with 10+ columns of formulas for a number of rows that will be determined in...
August 22nd 10 11:46 AM
by johannes2008 Go to last post
0 85
ComboBox autosize by GIP
What do I have to do / what properties do I have to change in order to prevent my ComboBox / text in ComboBox, from chaning size every time I select an entry...
August 21st 10 04:50 PM
by GIP Go to last post
0 72
1 Attachment(s) Filter rows on sheet 2 when a certain option is chosen on sheet 1 by GIP
I'm in excel 2003. I have two worksheets in my excel workbook, "home" and "Data". In the "home" sheet I have a combo box asking the user to choose one of 4...
August 19th 10 07:48 PM
by GIP Go to last post
1 115
1 Attachment(s) Help with excel worksheet functions by lisalou24
Hi I have created a client spreadsheet and I want to know if I can double-click on a cell to bring up certain information? As I have lots of different...
August 12th 10 02:13 PM
by wickedchew Go to last post
1 137
finding data for customer pay and warranty by dew23456
I am trying to find out how much gross sales are related to repair orders that have a combination of cash and warranty on the same RO. Any combination of pay...
August 11th 10 05:21 PM
by dew23456 Go to last post
0 101
Post New Thread


Display Options
Showing threads 1 to 20 of 86593
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:22 PM.


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