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 146
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 473
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 219
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
Sorting by
I have office xp. I'm new to excel and having trouble sorting a column of names. The sort tool is grayed out no mater what cell I select. If I start a new file...
May 28th, 2004 05:45 PM
by Frank Kabel Go to last post
3 105
color tabs on excel worksheet by
I am interested in knowing about the excel spreadsheets where u can color code the tabs
May 28th, 2004 06:09 PM
by Harald Staff Go to last post
2 314
Custom Function & Personal.XLS by
Excel 2000 SR1, Win2kPro Using a custom function works fine if the module is in my current workbook, but when I move the function to the module in my...
July 30th, 2004 07:04 AM
by Frank Kabel Go to last post
1 344
Excel by
I have a column with six numbers. I made them to be text. Now I want to separate the whole column into 2 columns one with the first three numbers & one with...
May 24th, 2004 09:49 PM
by Frank Kabel Go to last post
1 109
Dynamic Ranking by
I have 8 columns that need to be "re-sorted" everytime there is a real-time stocl price change. I am using the Large function to sort the price change, then...
May 20th, 2004 08:51 PM
by Peo Sjoblom Go to last post
1 109
comparing values for matches by
I would like to set up a cell to look for a number match for a cell next to it in another worksheet and over many columns and rows. Does the value in...
October 27th, 2003 09:55 PM
by Go to last post
2 190
Simple Countif problem by
I have a list of values A4:A24. In cell A25 I have used the average function. I would like to count the number of occurences in my list of values that are...
October 29th, 2003 12:43 PM
by Go to last post
2 322
Formula help.... by
Is there a way to find the following with one formula: NAME Score A1: Larry B1: 28 A2: Joe B2: 45 A3: Hugo B3: 25 A4: Jim B4: 42 A5:...
December 23rd, 2003 07:59 AM
by Norman Harker Go to last post
6 124
How to lock one cell in formula? by
There are two types of cell references -- relative and absolute. When a relative cell address in a formula is copied, the actual address is modified to...
December 26th, 2003 01:22 PM
by orlando Go to last post
2 558
percentages by
how do you calculate the percentage increase when only your base number is a negative value? And is there an excel formula that will do this?
December 24th, 2003 04:38 PM
by Go to last post
0 127
printing several sheets as one by
I have several sheets, but not all sheets fill one page when printed. I would like to append those sheets that fill less than a page together, so when I print...
December 31st, 2003 03:58 PM
by Dan C. Go to last post
1 295
Changing date format to text only by
format the cell as mmmm dd"," yyyy will give the result, set it up as a custom format, Format Cells Custom (at the bottom of the drop down list box) set up...
January 1st, 2004 07:37 AM
by Go to last post
0 536
Loops by
I need a loop function in excel... is there such a thing? What I need is for excel to look over a range of cells and if there is data written in the cells to...
May 13th, 2004 03:12 PM
by Go to last post
3 265
Total for negative amount by
Hi all, Need you advise on how to Sum-up the following amount only total the negative sign amount (from range A2 to A13) and the results is...
September 20th, 2004 01:58 AM
by duane Go to last post
2 133
Post New Thread


Display Options
Showing threads 87661 to 87680 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:55 AM.


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