I need to add the 'date last modified' of one spreadsheet into a cell of
another spreadsheet and have it update whenever the spreadsheet is opened.
i.e. in cell A1 of spreadsheet B, i would like to show the date last
modified of spreadsheet A and whenever spreadsheet B is opened ...

If this question is out here twice, I apoligize.  I submitted it once, but
don't think the question got posted.
I have 6 tabs in an Excel worksheet.  I create a 7th tab by consolidating
all the data from the other 6 tabs.  Is it possible (by using a function) to

Is it possible to turn off your find and replace function in Excel?

Hello~
For each row in my report I need to add columns ES:EZ and determine if the
val is equal to zero, then return a count of all rows where columns ES:EZ
added up to 0 .

I've got a column of IP addresses in another worksheet. I want to find the
most common IP address, so I use this formula: =MODE('18th'!C:C) where "18th"
is the worksheet and C is the column for which I want the mode.
The result is #NUM!

I have a range of numbers between 1 and 25 in 50 cells.
How could I use the countif function to look at that range of numbers for
values between 5 and 10 and count those values that meet the criteria of
between 5 and 10?

I have a worksheet with about 28000 records that I pulled from M
Access. The phone number column is left justified and has a littl
green arrow indicating there is an error of some type. The erro
balloon says " the number in this cell is formatted as text or i

How do I wright a formula by converting number 1 to January 2006, Number 2
to February 2006 and soforth?
Thanks
Soth

I'm having trouble concatenating a text string with a date:
I cell a1 I have the date 03-may-06
In a different cell I have the function:
=CONCATENATE(" This date: ",a1)

I am trying to use the vlookup function and it is returning the value in the
cell in the row just above the appropriate value in the table I am searching.
For example, when my lookup_value corresponds to A3 (in the table below),
the function is returning B2:

Is it possible to use a cell value (a text value) in a filename? Have tried
to set the value of the a variable to cell value than incorporate that into
the saveas method but to no avail. Any help appreciated.
Neil Beddell

How can I put all of three of these if statements into one cell?  For
example I want to say if it equals the 1st one than this is true but if
it equals the 2nd one than this is true, if it equals the 3rd one than
this is true but if it doesnt equal any of them its 0

Can someone please help me. I just learned how to angle my cells. But once I
type in those cells I lose my lines surrounding the cell. i checked they are
still there (in the formatted cells). but even in print preview they are gone.

hello, i want to use a COUNTA function to count the occupied cells in each
column in an excel spreadsheet.  However, the cells i want to count are every
4th cell & not the ones inbetween.  i can use =COUNTA(c7,c11,c15,c19....) but
my list size goes into to 1,000's & i only know ...

I hope this is the right board, so here goes...
Hi all,
I know this has been covered many times over, but I just can't seem to
figure it out. I have an excel file that contains 93 tabs, all with the