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
Help with a formula. by
I am trying to simplify a formula on a worksheet that sums the same cell on 50 other worksheets all within the same workbook. I can do it the long way of...
September 25th, 2003 04:43 AM
by Go to last post
2 142
funcres.xla by
funcres.xla is not found on my pc so analysis toolpak (yield, regression) do not work. where can I get funcres; download? tks mike
May 26th, 2004 03:01 PM
by Frank Kabel Go to last post
1 249
Need help writing formulas for following functions - by
I am building a spreadsheet which only needs to contain a few fields but I am having great difficulty getting the calculations right. If you can help I would...
May 30th, 2004 09:32 PM
by Go to last post
4 135
EXCEL Help Please by
When i do my accounts like so 150.00 and press enter to add the total the decimal point changes to a square.
June 1st, 2004 05:19 PM
by Go to last post
3 116
Formula is sending me over the edge by
This formula works when 47780 is input into D8, however, it does not work if C,P or 53S is in D9: =IF(OR(AND('Appendix...
June 25th, 2004 07:52 PM
by Harlan Grove Go to last post
4 152
Blank Cell by
Hello from Steved The formula below works, =HOUR(IF($T$40.5,$T$4-0.5,IF($T$41/24,$T$4+0.5,$T$4))) &TEXT(MINUTE($T$4),"00")) but when I add...
June 25th, 2004 10:27 PM
by Steved Go to last post
5 141
How do I format by
I have a page of marketing leads with names, addresses, phone numbers, etc all running togeather on a MS Word doc. I want to copy it to a MS Excel spread sheet...
July 5th, 2004 02:10 PM
by papou Go to last post
1 104
How to search and add an additional reference in a cell by
To Julie, Frank or any other lords of excel. I am trying to consolidate several spreadsheet into one=20 using the same template and format per sheet. Because...
July 15th, 2004 10:43 PM
by hgrove Go to last post
1 123
Trim leading zeros by
How do I trim leading zeros from a cells? 000000023 000000003 000000010 Thanks!
August 12th, 2004 03:28 PM
by sulprobil Go to last post
2 320
selecting certain rows by
I have a macro that selects rows based on their data. IE. x = Application.WorksheetFunction.Match("AIR", Range ("J:J"), 0) y =...
May 30th, 2004 02:43 AM
by DK Go to last post
3 174
Drop-down List by
Go to Data- Validation and then you will choose List (where you will hard code the values in the drop down). Hope this helps. -----Original...
May 8th, 2004 01:02 PM
by Debra Dalgleish Go to last post
1 160
Indirect Funtion by
Is there a way to fill down and right a cell that has the Indirect Function in it that alters the second cell referrence. As an example, if the first funtion...
October 24th, 2003 08:23 PM
by Go to last post
2 190
Problem with indirect from cell on external worksheet by
I am having a problem indirectly addressing a cell on a second worksheet (that is open). I found this article and when I tried the example it did now work...
November 17th, 2003 10:09 PM
by Harlan Grove Go to last post
4 122
Cannot merge cells, old spreadsheets, new Excel by
Using Excel2002, having upgraded from Excel'97. Whenever I open up an old spreadsheet, the "merge cells" command is not accessible. It it grayed out on...
December 8th, 2003 09:16 AM
by Bob Phillips Go to last post
1 466
my arrow keys!!!! by
my arrow keys are shifting my entire workbook columns/rows instead of just moving from cell to cell! how do i fix this?
January 20th, 2004 03:19 AM
by RagDyer Go to last post
2 420
Hide Column Help Needed! by
-----Original Message----- Hi, I hid two columns in my excel spreadsheet and now I want them back. How can I do this? Please...
January 21st, 2004 06:23 PM
by Go to last post
0 114
printing excel spreadsheet in word by
How do I get the gridlines to print in my word document using XP?
March 25th, 2004 10:43 PM
by Go to last post
0 214
column comparision counting. by
I have a spreadsheet that i need to compare columns. in column a is the lookup value. in column b,c and d is data to compare to column a i want to compare...
April 19th, 2004 10:27 PM
by Frank Kabel Go to last post
7 499
Month calculating by
=3DDATEDIF(A5,A66,"M") A5 =3D first date A66 =3D second date M for months Should work. Nav.
April 22nd, 2004 01:24 PM
by Go to last post
0 111
excel formula by
I have a spread sheet in which column A has Account numbers and also Salary. So A1=Smith and A2=5,000. and so on. In another sheet, I would like to have...
September 10th, 2004 06:35 PM
by Frank Kabel Go to last post
1 94
Post New Thread


Display Options
Showing threads 81 to 100 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 04:39 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.