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
Linking Error : produces a "0" by
I am trying to link information from our main office copy to our invoice copy so that when you enter the Co. information, etc that it transfers over. I have...
October 22nd, 2003 09:16 PM
by Go to last post
1 166
=, match or ??? by
you can use the following worksheet method: Workbook_SheetSelectionChange. with it u can check if a cell within target (a paramater of this function)...
April 17th, 2004 10:42 AM
by Frank Kabel Go to last post
1 126
MORE XIRR vs. IRR help by
I had posted this yesterday and did not recieve a response - I included prior questions for reference... What I'm trying to do is use the most accurate...
June 8th, 2004 06:48 PM
by Go to last post
2 786
Missing XLODBC.XLA for Excel 2003 by
Hi We want to use the function SQL.REQUEST in Excel 2003. The help suggests that it is in the XLODBC.XLA addin which can be downloaded from the Office Web...
July 28th, 2004 12:09 AM
by hgrove Go to last post
2 379
Gotit by
Nevermind, got it
July 16th, 2004 12:23 AM
by Don Guillett Go to last post
1 123
Index headache by
I'm using the folowing formula to locate a specific cell and return the value in that cell based on matching 2 different values to values in cells to the side...
July 16th, 2004 01:07 PM
by Arun Jhalani Go to last post
2 135
Date options by
I have been trying to enter the date as June 2004, but Excel will not allow this simple option? I've tried other options, but the closest I can find is...
July 27th, 2004 12:40 AM
by Go to last post
2 110
Drag Handle by
Is their anyway you can set the drag handle to cover a set distance each time i.e I want to cover 143 cell downward and 6 cells in width, can you set it so a...
July 28th, 2004 05:57 PM
by Bernie Deitrick Go to last post
1 117
Formatting cells by
When I fill a cell with a colour it is not being displayed - but when in print preview it is shown. Any suggestions?
August 22nd, 2004 12:32 PM
by Debra Dalgleish Go to last post
1 73
how to hide an excel sheet by
Is it possible to have an excel workbook and hide just one sheet in the workbook so that it can only be viewed by password? I know how to protect the sheet,...
March 31st, 2004 07:00 PM
by Harald Staff Go to last post
2 95
Excel XP (2002) Auto Filter problem by
I turn on autofilter to limit my view of data in my list, I then try to change the contents of the viewed data; but the underlining hidden data will also...
February 29th, 2004 08:21 PM
by Ken Wright Go to last post
1 261
worksheet matching by
can anyone offer guidance on trying to take one smaller worksheet with specific numbers without attached costs and match it to a larger worksheet containing...
October 23rd, 2003 04:32 PM
by Ken Wright Go to last post
3 104
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 01:43 PM
by Go to last post
2 316
Calculating weekdays by
Further to my earlier post, one of the machines is using Office 2002 (XP) it doesn't like the Networkdays function, can anyone assist with a work around,...
November 14th, 2003 09:36 AM
by Mark Go to last post
2 148
formulas by
can I get the cube root of a number? All I see available is the square root.
November 15th, 2003 09:16 PM
by Go to last post
2 119
Locking other cells based on values in a cell by
| A| B| C| D| ------------------------------------------ 1|Task |Desc |Hrs |Date | 2|Stucco | 3|Paint | 4|Plumb | Lets say above is my sample spread...
January 13th, 2004 01:53 AM
by Dave Smith Go to last post
3 674
Countif Formula by
I am using a formula in cell C1 =3Dcountif(B9:B500,"500") This formula will look in column B (which is a column with=20 values in =A3's) and tell me how...
January 13th, 2004 05:17 PM
by Bob Phillips Go to last post
5 122
Filter and delete by
I was able to filter non-blank rows. Now how do I delete those blank rows and turn off the filter?
February 27th, 2004 05:00 PM
by BrianB Go to last post
1 202
Max number in cell by
this is the main part of the formula. if you could trim this down, I would apply the changes to the rest of...
February 28th, 2004 09:41 PM
by Go to last post
3 99
List Boxes by
Hi All, How can I make a list box that has a series of values that are based on the values selected in another list box. Example List Box 1 A B
September 14th, 2004 10:27 AM
by mangesh_yadav Go to last post
1 250
Post New Thread


Display Options
Showing threads 141 to 160 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:12 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.