I'm trying to stop the #NA error from an array formula but can't get
it.
The formula is   =if(ISNA(TRANSPOSE(NameList)),"",TRANSPOSE(NameList))
The formula is entered as an array across 15 cells. Any solutions?

I would like to set up a cell so that it can be either a writable field or it
will pull from a formula depending on other things in the spreadsheet.  More
specifically, if the current date is after a point I want the field to
display data from a formula, but if it the current ...

Is there a way to add the numbers in row 2 that have the same date so that if
the result is Equal to, OR, minus 1 to 3 before, OR, plus 1 to 3 over (say
30), then diplay the result, otherwise display nothing?
Formula needs to be in row 3 and if the date are different, as in B1, ...

Hello,
Hopefully this makes sense to some one. What I need is two things first:
I need cell A2 to display today’s date if a 1, 2, or 3  is typed into E2 and
have that happen all the way down the sheet so as I enter data it fills the

The search function only lets you look in one cell.  
Why can't you use:  search(4,B2:B10)
is there something that can just tell me if there is a 4 in that range?  I
dont want to use vlookup, i just need to know if it is true or false

I've a workbook with names in range A1:A10.
In another workbook there is a list (the length is every week different) and
I want to compare this list with the 10 names on my first worksheet.
I want a list of the people who are in that long list, but not in my default

Can someone please help me with an error message for the following formulas:
=IF(I2="",0,(DATEDIF(I2,TODAY(),"Y")>=3)+0)
=IF(I2="",0,(DATEDIF(I2,TODAY(),"Y")<=2)+0)
It has only come up on this one computer.  It's fine on all others.  Have

I have a worksheet that has one column containing dates (D3:D1400)
In another cell I want to count the number of rows that have a date between
two specified dates, eg. 01/10/05 and 31/10/05.
Anyone got any idea how I would achieve this? Any help would be very much

Afternoon
Im currently matching up two tables of data using the Index function.
=INDEX(UPRNmatch.xls!Gaz,MATCH(N3669,UPRNmatch.xls!Match,0),1)
(Where Gaz & Match are range names).

I am using Excel 2003
I have two tabs in my file.
Tab 1 has account numbers in column A; in column C I want to put the cost to
date

I've got 12 columns (headed Jan - Dec), each of which contains a combination
of numerical & blank cells.  For each row, I want to select the first
non-blank cell and return the column header that it lies in e.g. Row 1, first
non-blank cell is in the Apr column, so I want the text ...

I have many cells where the numbers have a space or two after each one.  I am
not able to format them as numbers because of this and don't want to have to
remove them manually.  I have tried the Replace with but don't know how to
have it remove spaces. It says I must have a value ...

Ok, you guys helped be out big time with my last question!!! So here’
another.
I want A1 to = the current time (where I am)
B1 = Friends name

I have two columns to compare. I first sort them out in the same order and
then use the IF function. The If function is OK but when the rows to compare
are not match due to the error in typing or spaces then there is no match.
Is there another way or function to use that instead of ...

heloo
if i have 5 columns like these
1 microsoft 100 50
2 sakhr