What I would like to do is autofil a cell with hardcoded name when a cell on
the same row is updated.  I.E. if data is entered in cell B2,B3,B4 ETC. then
the 'hardcoded name' will be placed in B1

I was having issues with Vlookup functionality in a 2 column array.  It does
not recognize the value I have in the array intil I over type the value and
then the vlookup functionality works.
My equation looks like this:  =VLOOKUP(A2,$J$2:$K$5815,2,FALSE)

I am trying to do an average of values in a range of cells across colunms,
where only values other than zero are counted in the divisor. For example, I
have 4000, 0, 0 in my range and I want it to average the sum by 1, and not by
3 since the other two values are zero. If I then add ...

I am using an IF function to generate data for an array. Under certain
conditions a given cell should generate a totally blank cell, as opposed to a
zero value.  I have been trying to use a formula such as:
=IF(A10>A1,A10,"")

We have an excel spreadsheet that needs to be accessed by several users.
Currently, only one person can access at a time to input information. Can
several users access the spreadsheet and input information simultaneously?

I am building a spreadsheet that requires it to automatically generate the
last day of the month (for any month). I found the EOMonth function and every
time I use it all it returns is the "#NAME?" error message. I even tried hard
coding the function (=EOMonth("01/01/2006",0)), ...

Can you base a vlookup formula on data that has been concatenated?

My excel worksheet will not multiply any formula with decimals

Is there a function that will add an entire row after a unspecified group of
number.
ie I have some numbers, these numbers could be negitave numbers and range in
string size.  There will be groupings and after each grouping upon a new

Hello experts,
Below is a sample of my spreadsheet.  Rows  1-31 is the day of the month;
colums B, C, D, etc. are formulas, adding days to the date in A1.  Up until
today, I was able to key in only a new date in A1 and the entire spreadsheet

I have a list of costs displayed against various building elements.  
The elements are in a fixed order but the resulting associated cost
will be a random turn out figure. I want to extract the maximum cost
and display this cost with the associated label e.g.  Brickwork

I am using an "if" formula.
This is what I wrote =if(B2<>"","Dear B2,","To Whom It May Concern:")
The value in B2 is "Nancy"  
This formula gives me the answer of "Dear B2,"

I'm pretty sure this isn't a "function" question, but I don't think there's a
better place to put this.
Is there a data validation setting that I can use to force users to enter
four digits? For instance, 1125, 1362, and 0734 would all be valid entries.

How do I use the TODAY() formula in the SUMIF function?
I'm tracking training time and I  want to sum only the hours completed, not
the hours to be completed.
Example:

I have a column of cells, only 1 of which will have a value in it.  I would
like to assign this value to another cell.  Basically, i'd like to use
something like the Max function (because i have to check a range of cells)
but the data is a date.  Is this possible??