|
|
|
|
5 |
215 |
|
|
|
|
2 |
180 |
|
|
Validation list with formula? by
SaM
I'm not sure I am going to explain this right - but here goes. I have a
project open in excel - the main page is a form to fill in, with which I use
drop...
|
|
3 |
157 |
|
|
Formula referencing a changing range?? by
Stacie2410
I have a workbook that has several tabs. I'm only working with 2 for the
problem that I'm having though. The first tab, which holds all my data, is
called...
|
|
3 |
205 |
|
|
|
April 14th, 2010 10:39 PM
by Casper
|
4 |
174 |
|
|
Relative Link remembers absolute path?? by
booker@mgt[_2_]
I have a linked file that has about 6 source files that it is dependent on.
The links have been setup relatively. The user's open the source files and
the...
|
|
2 |
165 |
|
|
2 worksheets--3 questions by
Anne
Hello! I have a workbook that tracks patients (mothers) and contacts (mom's
family members). The mother worksheet is named MAT_INF and the contacts one
is...
|
|
3 |
177 |
|
|
Protecting Sheets with drop down boxes by
Dolores Gomez[_2_]
I have a spread sheet that has drop down boxes with functions and
validations. I want to be able to protect this spreadsheet so that users can
only be able...
|
|
1 |
171 |
|
|
|
|
2 |
142 |
|
|
Changing Source Data using V-lookup by
Kevin
I am trying to use one spreadsheet that has v-lookup formulas in it and
change the source data sheet with the current month's information. When I
change the...
|
|
2 |
228 |
|
|
data links on subsequent worksheets by
TerriK
I have main data entered on worksheet 1 that I have linked to subsequent
worksheets, however when there is no data on worksheet 1 I get 0's printed in
the...
|
|
2 |
168 |
|
|
Help needed with If & Today function by
Nemo
I have a row where I have dates of the month - C2:AG2. I want a formula,
where if I enter a text in the corresponding row, and if the date is not
todays...
|
|
4 |
222 |
|
|
vlook up w- multiple variables by
chilitodd
For my vlook up in excel 2007, I want to return data to populate cell B2
(xxxx) from column 3 ($21,745) of a data set when the value in cell A2 (360
19318)...
|
|
2 |
184 |
|
|
Auto Calculate Keeps Resetting to Manual by
Shirley
Cannot get this to stay at automatic. Any thoughts why?
New workbook, nothing complicated (b2/b3). I save the document, reopen and
set to recalculate. The...
|
|
2 |
189 |
|
|
invisible color by
cindyhosch
I can only see blk/white on my worksheets. I can change text color and/or
highlight a cell and it appears as though nothing happened. But - when I
pull up...
|
|
4 |
125 |
|
|
=INDEX(AF1:BD108,MATCH(Z3,AD2:AD361),AF:AR) by
excelrookie
Anyone see the problem with this, it isn't working. I am tring to put all
the results (in columns AF:AR) into a cell, based on the input Z3 (The input
will...
|
|
2 |
164 |
|
|
|
|
4 |
161 |
|
|
If argument by
DonaMil
I am looking to portray an argument that "if" a certain text is entered into
a given field then another field which is used as a calculation would return
an...
|
April 14th, 2010 04:20 PM
by Eduardo
|
1 |
119 |
|
|
|
|
3 |
164 |
|
|
|
|
5 |
237 |