I use the following formula to generate time from a particular date to
when and exam was conducted:
=IF('Details'!M6="","",($I6-MAX('Details'!$M6,DATE(2009,4,1)))/7)
the output of this is then put through Data - Analysis to produce a

I forgot to mention that the xldynamic site is back up, I have resolved my
host provider.
I still have to fix the downloads, but eveything else should be working.
Bob

I am creating a data entry page in which I want to use data validation Lists
to select the product that I want to enter. How ever each cell may be
different from the one above. For example in (c4) I want to enter pipe data.
I have a sheet named pipe as the source for this entry. ...

Is there any way to protect a worksheet so that when any cell is
selected it displays the value in that cell instead of the formulaes.
Thanks
Neil

I have a list of numbers. Each row has a number representing
investment, followed by a number representing a return. I then
computer a percent of return as a percentage.
There is a group of these over several rows. I'd like to rank each

I had my resume on the desktop in a scanned folder )zip file) I right clicked
and chose import to microsoft excel.  When I opened the file it was in
microsoft excel non-commercial and is now gibberish.  WHAT DO I DO TO
RETRIEVE MY RESUME??  It is 4 pages long.  I am using ...

Is there an easy way to do the above.
Thanks much
Carl

I’m having problems finding a way to auto copy rows of data from one
worksheet to another depending on a date entry within the data row. I’ve
created the following simple example to illustrate what I’m trying to achieve.
I have a workbook containing 13 worksheet tabs.

For example, In excel in cells A2 to A56 I've got words in them, I wanted to copy all the cells in column A to B in same order,but when the word "check" is encountered, a blank cell will be added below the cell with the word "check". How can I do this?Help...
EggHeadCafe - ...

Need for conditional formatting to be TRUE if a cell is equal to any
of several cells.
Trying to use conditional formatting formula in cell A20: =IF(G20=J$8:J
$12,TRUE,FALSE) so as to have the condition (color condition for A20)

I have a large list of names and telephone numbers which is used to
populate cells in a multisheet workbook. I have this list on a worksheet
called 'List' along with many other such lists all ranges are allocated
a name for easy insertion into the main sheets..

The following converts latitude co-ordinates in cell A3 from NN:NN:NN and
N:NN:NN format to N.NN format.  (A similar formulae does the same for
longitude co-ordinates.)
=IF(RIGHT(A3,1)="W",IF(MID(A3,2,1)=":",(LEFT(A3,1))+(MID(A3,3,2)/60)+(MID(A3,6,2)/60/60),(LEFT(A3,2))+(MID(A3,4 ...

Is there a way of displaying values on the y axis in a non-linear fashion?
In other words, having the values closer nearer to the x axis.

i want to print numbers entered as numbers in words like 1 is one,20 as
twenty  also to have two decimal places

if one
selected a self contained range( no reference to outside the range) with
formula from excel 2003 (like using RDP on another pc), copy then paste to a
local Excel 2003 somewhere on spreadsheet tab.