|
|
External reference is not valid ??? by
Mason C[_2_]
I have a sheet that persistently reports, "External reference is not valid"
I can't find the invalid reference. How can I find it?
Thanks for any...
( 1 2)
|
|
12 |
240 |
|
|
|
|
4 |
103 |
|
|
vlookup by
Jim
Hello,
I am using the following vlookup formula: =VLOOKUP(A2,SF_Input!A:I,10,FALSE)
however i am receiving an error: #REF!
I have also tried the following:...
|
October 23rd, 2009 08:06 PM
by MParham
|
6 |
83 |
|
|
Cell reference between worksheets by
Cassie Rodgers
I have a spreadsheet that has multiple worksheets. The first worksheet is a
status tracking tool for the other worksheets which contain all the daily...
|
|
4 |
162 |
|
|
Printing a form with a drop down list by
nickATnite
I have a form that has a drop down list of different equipment numbers. Is
there a way I can print the form with it automatically putting in the next
number...
|
|
2 |
97 |
|
|
excel mru list by
George Applegate[_2_]
If I have excel open twice on the same PC (different monitors) and I
save each file, if I look at the MRU list in excel, it doesn't show
them. This is excel...
|
|
1 |
105 |
|
|
Share Excel file in Compatibility mode by
Brown Recluse
I have an Excel '07 file that I created for shared use; however, the users
all have '03. I'd like to keep it in '07 due to size. I had them download...
|
|
0 |
101 |
|
|
Error Message by
RS
I am using a predesigned template from Microsoft for Loan Amortization. I
want to enter a decimal number instead of a whole number in the cell for
years. ...
|
|
2 |
111 |
|
|
Complex Match by
Vic
I have 2 worksheets: "Main" & "Other". Both have 2 columns.
"Main" & "Other" have identical Column A - Invoice number 10 positions
(positions 5, 6 and 7 will...
|
|
3 |
129 |
|
|
|
October 23rd, 2009 06:21 PM
by Shawn
|
4 |
97 |
|
|
If then by
JJP
Hello Everyone,
I am rather new to excel and find it is a very adaptive tool for use in many
ways. I am trying to create a spread sheet that keeps track of...
|
October 23rd, 2009 06:10 PM
by JJP
|
4 |
78 |
|
|
Salary by Qtr Formula by
KC
I'm trying to calculate by quarter how much an employee will cost depending
on when they are hired. I have a column for 4Q09 (Col R4), 1Q10 (Col S4),
2Q10...
|
|
1 |
113 |
|
|
Boolean Values in Pivot Table by
ExcelMonkey
I have a pivot table feed off a table 2 column talbe with booleans in teh
second column. I want te count the TRUE occurences. However the Count
property of...
|
|
1 |
105 |
|
|
Add Same in each cell in column by
S1L1Y1
I am trying to add the same words to the beginning of each cell in a column
like for example the following ""abc.com/catalog/" to the beginning of the...
|
|
1 |
105 |
|
|
Several target cells in the solver by
omathilde
Hi
I m using excel 2003 and I would like to know if it is possible to set
several target cells to the solver.
As we have several adjustable cells, is it...
|
October 23rd, 2009 05:06 PM
by walter
|
4 |
109 |
|
|
|
|
2 |
108 |
|
|
|
|
3 |
91 |
|
|
losing command button functionality by
smokeyspal
Hi, my question is this:
I recorded a few macros for clearing the contents in ranges of cells.
I gave the ranges names, ie. "cellstoclearplow" These macros...
|
|
4 |
80 |
|
|
Excell 2000 worksheet help by
ChristyG
I am trying to re-create something I have seen in an excel worksheet. The
auther had a line beneath the header and to the right of one column. This
"line"...
|
|
3 |
85 |
|
|
Excel 2007 time calculation by
jtucker
I export time statistics into Excel 2007 so that I can get totals for
multiple entries. The time format is hh:mm:ss and in the hours field it adds
a leading...
|
October 23rd, 2009 04:37 PM
by Pete_UK
|
1 |
81 |