Hey, I'm having these (hopefully simple problems) with writing in page numbers:
1. I want to write ex. "7-19" in a cell -
Then in another cell I want excel to give the "result" of the interval of,
here 12.

I wondered if you could help out a friend of mine - I'm just passing on his
message:
--------------------------
I'm trying to automate some coursework tasks for the new course and would

Can you please help?
I have 6 pieces of info in cells A8, A9, A10, A11, A12 & A13 - Cells C8
to C13 are merged and contain one value, if i use the filter option and
choose the value contained within the merged cells, it only displays

I have a folder with a number of identical workbooks each one saved under a
different department.
Each workbook contains 13 worksheets identified as Wk1 to Wk13 representing
13 weeks

Having prduced a list of values from using the & concatenate method, I
want to end up with a list of only those which have a positive (over 0)
number. So I have:
(155), (111), (51), (0), (0), (0), (0), (0), (0), (0)

I have a table with columns Expiry / Strikes / ... / ... / Price with
hundreds of lines
Basically I need to retrieve the field price corresponding to one line
meeting two criteria of Expiry and Strike (as for exemple Decembre and

Is there anyway I can create a message to appear on screen if the figure in
cell F15 is greater than the figure in cell F22, as the figure in F22 is
always greater.
Thanks

Anyone know how to setup a command to auto delete a row in excel?

I need to convert the date format dd/mm/yyyy to yyyymmdd.
How would I go by?
TIA
Ana

I have a problem surrounding sumproduct and setting criteria.
I need to sumproduct based on row criteria '19:19'. The value for the
row criteria is set in an other cell 'E23'.
So sum of row 9 and row 17 where 19 is equal to E23.

I am looking to find a way to have information that I type into one
page, automatically update into another page. I don't want to have to
use the cut a paste method anymore, after having to do this with like
pages and pages, information starts to get pasted into the wrong area

Upgraded to Office 2004 recently.  Well, now, whenever an Excel doc
comes up now, and I use the scroll wheel (Kensington mouse) to scroll
up or down the page... I get zooming instead!
This is on a Mac running Tiger and, though I've looked and looked,

I would like to set a formula in a cell to sum up the value of all nonblank
cells.
The detail is that I got a data file download from a system, column C
contains local value and column D contains the USD value, not all the USD

Is there a way to perform a function which display the formula of the target
cell (NOT the value of the cell)?
{Fictitious function}
ShowFormula(TargetCell)

Hi, I'm traing to use excel to admin h24 workers. They are payed in a
different way if they work on sunday, by night, or in some special days and
dipending on the tape of work.They can be payed in two different way in the
same day. I'm lost and cofuse. At the moment I've got so ...