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
histogram by
Im trying to make a histogram, and i can't get it to work at all. I go to tools, data analysis, select histogram, and then i have no idea what to put into the...
September 17th, 2003 06:57 PM
by Tom Go to last post
1 297
Limits for the MMULT function by
-----Original Message----- Hi, I'm trying to multiply 2 matrices of 75 rows x 75 columns using the MMULT function, but Excel shows the #VALUE error... I...
May 25th, 2004 07:20 PM
by Harlan Grove Go to last post
1 198
Pivot Table by
Need your help. am Not be able to get the total # for the following info in Pivot table there is only one total for q1 q2 1 1 3 3 2 2 3 2 2 2 1 2
May 26th, 2004 03:12 PM
by Frank Kabel Go to last post
1 120
paint cells with highest numbers by
How do I get excel to paint the cells with say the 14 highest numbers i a defined area of the sheet?
May 26th, 2004 02:56 PM
by Frank Kabel Go to last post
2 215
NEED HELP: ADD-INs by
funcres.xla is not found on my pc so analysis toolpak (yield, regression) do not work. where can I get funcres ( download) so addins work? tks mike
May 26th, 2004 02:54 PM
by Frank Kabel Go to last post
1 133
formula help by
i need help =if(K740,K7-40,0) now k7 is going to equal =sum(C7:J7) but if K5 .00 then K5 needs to be subtracted from K7 i need help righting this formula
June 18th, 2004 01:34 PM
by Go to last post
7 105
calculating dates based on workdays only by
-----Original Message----- I need to calculate completion dates based on a start date, a duration, and utilizing only work days. . When I was running...
July 20th, 2004 03:48 AM
by Daniel.M Go to last post
1 351
Change printer Macro by
I tried the below formula and it doesn't work properly. It's a macro. What I would like to do is print certain worksheets within a workbook on...
August 3rd, 2004 03:05 AM
by Dave Peterson Go to last post
1 285
Conditional Cell Formatting by
I am trying to point the conditions of 'conditional formatting' to a formula in another cell. Is there an easy way to do this?
August 25th, 2004 08:25 PM
by Frank Kabel Go to last post
2 83
inserting worksheet name in cell using function by
I have found a formula on the web help site to automatically insert a worksheet name into a cell of the worksheet. I have several worksheets and wish...
May 25th, 2004 07:11 PM
by Gord Dibben Go to last post
2 464
Pivot Table "Show All" Check Box missing in Excel 2000 by
Hope someone can help with this. A large array of data I have is sorted and filtered using a pivot table. Works well in XL2002 & XP, being able to uncheck...
May 7th, 2004 03:45 PM
by Curtis Go to last post
2 444
MACROS by
I have macros setup in a worksheet with macro buttons set to run these macros. Everything was running fine until I saved this worksheet to a different name....
October 20th, 2003 02:48 PM
by Go to last post
0 193
Send add result to next sheet by
I need to copy/send an 'add' result to a cell on the next sheet. a+b+c='d' where 'd' is then copied to a designated cell on the next sheet. If d 0 then copy...
December 10th, 2003 09:49 AM
by Andy B Go to last post
1 243
Microsoft excel link to microsoft word by
Does anyone know how to take anumber from a calculated formula in an excel worksheet and enter it automatically into a word document without cutting and...
January 28th, 2004 07:50 PM
by Go to last post
0 109
converting imported numbers by
I have imported a text file containing numbers that I need to change/move the decimal left 2 places i.e I need convert/change 123 to 1.23, 123456 to 1234.56...
January 30th, 2004 06:51 PM
by Go to last post
4 350
Sum of total time in arange of cells by
Hope everyone having a nice day. I've number of cells with total time (i.e. 4hrs and 30 min as 4:30 and so on). I want to add all of these times to have a...
February 11th, 2004 05:49 PM
by Frank Kabel Go to last post
6 639
SUMIF/COUNTIF with Multiple Arguments?? by
I've got a data set with two columns that I'd like to summarize by COUNT and SUM. eg. Status Variance NP $(50,000) P $ 25,000 P ...
February 18th, 2004 10:51 PM
by Kent Go to last post
3 418
Formatting the outuput of @Concatenate by
Hi I have the following function in a cell: =CONCATENATE(YEAR(B3)&MONTH(B3)&"-"&UPPER(LEFT(B4,3))&"- "&DAY(B3)) It generates the following output:...
April 12th, 2004 08:21 PM
by Go to last post
6 116
Printing excel 2000 formulas by
I printed the formulas contained in an excel 2000 worksheet several years ago but I can't remember how it was done. Please help. Blue
April 12th, 2004 11:16 PM
by Go to last post
0 524
List Box by
How do you put multiple columns into a List Box
September 7th, 2004 10:57 PM
by Frank Kabel Go to last post
1 104
Post New Thread


Display Options
Showing threads 101 to 120 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 06:40 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.