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
how? by
HOW TO CONVERT $ TO INR ? BY APPLYING A FORMULA ?
September 22nd, 2003 03:13 PM
by Pierre Go to last post
2 141
please help again by
Michael helped me with part of this earlier today. I'm stuck again. The below formula works well; however, I want to add "(35200)" and "(35300)" to the...
June 9th, 2004 07:58 PM
by Go to last post
2 123
Date counting formula by
What is the formula to count the number of days only between two dates
June 9th, 2004 10:49 PM
by Frank Kabel Go to last post
2 130
filling series problem by
Sorry, other way around, I want it to fill like: Sheet1 A1 Sheet2 A1 Sheet3 A1 but I get: =(Sheet1!A1) =(Sheet1!A2)
June 22nd, 2004 09:31 PM
by Alan Beban Go to last post
2 140
Difference by
In terms of funcionality what's the difference between =SUMPRODUCT((A2:D2)*(A4:D20=1)) and =SUMPRODUCT(($A$2:$D$2)*($A$4:$D$20=1)) This is with respect to...
June 22nd, 2004 10:26 PM
by TN Go to last post
2 80
Autosum by
What ever happened to the Autosum button? Is this no longer availl in excel 2000?
July 14th, 2004 08:26 PM
by Alan Go to last post
1 136
PERSONAL.xls by
The above file is more of a nuisance than a problem; however, it has been known to get very annoying. The problem is that each time I open the Excel...
August 13th, 2004 12:15 AM
by Gord Dibben Go to last post
2 224
Sum of Degree Angles by
Does anyone know how to sum degrees, my degrees are in cells. Example a1 105 52'08" a2 73 54'42" Thank you!
September 5th, 2004 11:30 PM
by Go to last post
3 117
convert degrees minutes seconds to radians by
does anyone know how to convert degrees minutes seconds to radians. I have tryed this and my number is off significantly.
September 6th, 2004 12:09 AM
by Gord Dibben Go to last post
2 289
please help with formula by
I tried the following formula and I should be receiving a result of 0 because I7 has "(001234)" in it, not "(00140)". For the record, K21 is greater than...
June 9th, 2004 04:20 PM
by Michael Malinsky Go to last post
1 93
sumif; conditional sum by
I'm trying to get a conditional sum based on the relation of the cells in the column to be evaluated to a fixed cell. If the amount in the cell in the...
April 26th, 2004 05:39 PM
by Nancy Go to last post
3 207
function by
i am not sure how to do this. I have a narray of numbers in colum a (a4:a121) of either 1 or 2. In colum f (f4:f121) is the same array. I would like a formula...
October 23rd, 2003 12:29 PM
by Jason Morin Go to last post
4 113
excel print formula by
I cannot seem to print the formulas on a excel 2000 spreadsheet?
October 23rd, 2003 03:45 AM
by Michael Puk Go to last post
2 151
Replacing cell of a column with cell of other worksheet by
Hello, I have the following problem. In one sheet I have a table with imported keys from an access table. Now I want to replace these keys with strings that...
November 28th, 2003 10:03 AM
by Andy Brown Go to last post
1 203
How to turn off the automatic date feature in Excel 2003 by
If you enter a number that is formated like XXXX-XX-XX or XX-XX-XX or XX-XX-XXXX ect. Excel automatically changes the formating for the cell from "numbers,...
January 14th, 2004 12:16 AM
by Don Guillett Go to last post
8 742
Formula not updating by
I entered a SUM formula and when I change the contents in its range the total is not updated. Any ideas?
January 14th, 2004 03:00 PM
by Bingo Go to last post
1 100
Slanting Cells in first Row by
I have a question for the Excel Savy crowd! I am looking to change the first row in Excel by changing the cell orientation. Actually slanting the cells! I...
(Multi-page thread 1 2)
February 27th, 2004 07:47 PM
by Bob Phillips Go to last post
14 859
vlookup question by
hi say i have colA and colB. i m using vlookup (in other sheet) to lookup for values in colA and returning corresponding value in colB. problem arises when...
March 18th, 2004 06:55 PM
by Frank Kabel Go to last post
5 235
conditional sum if by
I just recently started using the conditional sum if feature (array). I go through the entire wizard using an existing spreadsheet. The last step of the...
March 31st, 2004 08:16 PM
by Go to last post
8 154
Convert Number into Text by
In one column, I have numbers (120-1200). In another column, I would like corresponding Alphabetical representaion of the numbers. Eg A1 = 123.56 then B1...
September 13th, 2004 05:26 PM
by Frank Kabel Go to last post
3 112
Post New Thread


Display Options
Showing threads 161 to 180 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 07:15 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.