A Microsoft Office (Excel, Word) forum. OfficeFrustration

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 » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Reverse Sort Order Last Post Replies Views
IF Function Problem Excel 2000 by david@pcm
I'm trying to calculate a formula in Excel using the IF function. Here is my code. ...
September 28th, 2006 12:40 PM
by Lori Go to last post
4 61
Print to file by DavidA
Excel won't let me print. When I try to print, it automatically comes up with "Print to file" and when I press cancel, it cancels everything. Print to file...
March 17th, 2010 09:42 PM
by Billns Go to last post
5 150
Has anyone had formulas change automatically with no explanation? by DavidA3878
I have a user who is using a simple workbook with formulas pulling data between worksheets, but their formulas will change automatically with no explanation....
November 2nd, 2005 01:42 AM
by Alan Go to last post
1 79
Help with #DIV/O! by davidadiaz
I need assistance with this entry. I get this #DIV/)! in the middle of of a calculation, which will not add up properly. How can I relace it with a 0 ...
February 16th, 2005 12:08 AM
by davidadiaz Go to last post
0 65
Help with #DIV/O! by davidadiaz
I need assistance with this entry. I get this #DIV/! in the middle of of a calculation, which will not add up properly. How can I relace it with a 0 ...
February 16th, 2005 12:25 AM
by Steve Go to last post
1 63
Hot To Copy Pivot Table formats by DavidA[_2_]
In Excel 2007 I want to copy and paste special, both values and formats, from a pivot table into a new worksheet. The values copy and the values are...
January 23rd, 2008 11:03 PM
by ShaneDevenshire Go to last post
1 75
call external function by DavidB
How do I convert a column of IP addresses to resolved DNS names (eg using the Windows command line function nslookup() - I wonder why this isn't a standard...
March 16th, 2009 10:04 PM
by DavidB Go to last post
2 78
Cannot autosum after import by DavidB
Hi guys I'm importing numbers from a custom application into excel, after the import I cannot autosum, but if i manually remove the number and re-type it...
July 19th, 2006 04:39 PM
by Gord Dibben Go to last post
3 96
How do I sum using relative cell positions? by DavidB
I want to set up a formula that calculates a sum based on the data in the 12 columns to the left of the calculation cell. Something like: SUM(RC:RC), *but* if...
April 27th, 2005 03:44 AM
by John Mansfield Go to last post
1 78
have Excel retrieve conditional operator ( = ) from a cell by [email protected]
I'd like to enter "" "" "=" "=" "=" in a cell (e.g. cell E11), and then have a formula which evaluates based on that entry. (I'm analyzing a ton of data...
May 17th, 2007 07:16 PM
by David Billigmeier Go to last post
1 56
updating one spreadsheet with another problem by davidbev008
I have 2 excel spreadsheets, A and B. Each contain products that have prices. I need to update one of the spreadsheets (A) with the prices from the other (B)....
October 1st, 2005 02:50 AM
by Ragdyer Go to last post
1 384
Choosing Data and skipping other by DavidBr318
I wish to have Excel choos items from another worksheet according to the criteria I set (ie: if =1, then choose ... but skip if not = 1 and select the next...
October 14th, 2005 03:09 PM
by Richard Buttrey Go to last post
2 168
Copying formats - column widths, formats, outlining to worksheets by DavidBr318
I very often use worksheets to create a master workbook - it is tedious to re-create the formating of the master worksheet to each subsequent worksheet - In...
August 14th, 2009 05:03 AM
by Leanne Go to last post
4 103
Cell reference within array by [email protected]
I am trying to use a cell reference within an array, but Excel won't let me. In my case, here is the formula I want: =IRR(A8,50,50,50,50) A8 is a negative...
(Multi-page thread 1 2)
May 6th, 2009 02:52 PM
by Lori Miller Go to last post
10 168
Multiple SUMIF functions ? by davidbrowne17
now here is a tester for you all. the attached worksheet lists WEEK, EMPLOYEE, JOB, HRS. The first part of the sheet ( blue) is added to weekly, with...
February 26th, 2004 12:37 PM
by davidbrowne17 Go to last post
0 274
auto SUM a FILTERED List by davidbrowne17
When using the AUTO filter, is there a forumular to SUM the filtered list ( i.e Displayed items) I have used the SUM fuction, this will add up the current...
November 12th, 2003 12:52 PM
by Stephen Bye Go to last post
1 360
Excel changes decimal by davidcay
Newly installed Office 2008 for Mac inserts decimal, for example, 17 becomes 1.7. How to fix?
April 28th, 2008 03:15 PM
by Spiky Go to last post
3 104
In Excel, how can I stop the drag function to copy and not add? by DavidClaborn
I want to copy selected rows by grabbing the fill handle and dragging down. Currently, some columns are adding instead of just copying the number. How can I...
July 1st, 2006 10:50 PM
by Gord Dibben Go to last post
3 68
How can I use circular references that are allowed in Lotus 123? by DAVIDDON
I try to write a formula that has a variable value in column F which is compared to column H. Column H should always contain highest value of the two...
July 14th, 2009 09:14 PM
by Luke M Go to last post
1 106
Concatenate a Column of e-mail addresses by Davide
Is there a function to concatenate a column of 150 e-mail addresses to a single cell with each e-mail address followed by a comma and a space?
April 19th, 2007 04:10 AM
by Davide Go to last post
2 102
Post New Thread


Display Options
Showing threads 20081 to 20100 of 87787
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 Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:45 PM.


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