|
|
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
|
1 |
187 |
|
|
=, 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)...
|
|
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
|
2 |
801 |
|
|
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
|
2 |
379 |
|
|
Gotit by
Nevermind, got it
|
|
1 |
127 |
|
|
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...
|
|
2 |
145 |
|
|
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
|
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...
|
|
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?
|
|
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,...
|
|
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...
|
|
1 |
271 |
|
|
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...
|
|
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 12:43 PM
by
|
2 |
322 |
|
|
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 08:36 AM
by Mark
|
2 |
148 |
|
|
formulas by
can I get the cube root of a number? All I see available
is the square root.
|
November 15th, 2003 08:16 PM
by
|
2 |
122 |
|
|
|
|
3 |
721 |
|
|
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...
|
|
5 |
125 |
|
|
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 04:00 PM
by BrianB
|
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 08:41 PM
by
|
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
|
|
1 |
255 |