Hi this is the first time I've used this forum so I'm hoping someone ca
help.
Here's the problem I'm working on a Spreadsheet that needs to generat
variable intervals in dates between 2 variable dates (confused, so a

3Hi,
I have 2 fields which I need to merge into 1.  The formula I have so far is
=A1&"_"&A2
Cell A1 is text (Eg. AC) and A2 is a date (Eg. 01/01/2001).  I need the

How do I replace empty cells in a range of data with the special character - ?
I tried using the following method:
Selecting the range of data, Edit > Goto > Special > Blanks > Point to a
cell in the adjacent column with ' - '...

I appear to be having a little difficulty with sumproduct.
A1 = 01/06/2006       (dd/mm/yyyy format)
A2 = 01/07/2006
B1 = 01/06/2006

I am totalling hours and minutes for part-time staff in Excel. How can I get
excel to give actual total times where the total exceeds 24 hours?  

Please help me with following problem
If I have as an example following table:
    100    200    300    400
0,01    4    6    11    17

I created the macro, also got it run automatically whenever we open a
workbook.
Now, the problem is that this data is linked to charts (Pareto Charts that
need to be sorted) and the sheets that contain this data are hidden.

Is it possible to make a false result take absolutely no action. And I am not
looking for the....""...... That simply empties out the cell. I need a false
result to do nothing.

In the same spreadsheet I have the following scenario;
Tab "product index" in column A there are names of products like'
Apple
Orange

I have 3 input cells (data will change based on user input) :
A1  300  (value)       "start rate"
A2   10  (percent)  "decline"
A2   feb-07  (date as month and year)  "start date"

I'm trying to conver 425033 to 42:50:30
I'm running out of steam!

Hi all, I am new here and already I need some help in creating a formula
for Excel XP, I am sure I have seen something like this before, but
cannot figure it out, and so am hoping someone here can help me.
I have downloaded some data from SAP and want to move everything into

I am trying to have a Vlookup that pulls from another file. The issue is I
want the name of the file to be the value within a specific cell. For
instance, cell A1 has the value "File#1" (through a formula). I want the
vlookup to pull from File#1 without hard coding this into the ...

Does anyone know of a website or any way I can get a complete list of Excel
Formulas? I know there is a book now called Excel Formulas 2003... but I'm
looking for a site or something I can print out of just the formulas...ALL of
them if possible.

I am modifying my spreadsheet for a coming football cup for youths.
Today I have one sheet per Group (Boys89, Boys90, Girls90 etc.) and move
between sheets when entering in the results
The important columns are (A=Match.no, J=Result Home, K=Result Away)