Why will my destination file only update if the source file is open? If the
source file is closed, I get the error message: Unable to read file. Please
help!

Do you need to use a math tool?

I have a single row of data, which will grow, which I need to merge into a
long list of text in one cell, so I can paste into another program.  I have
started with the concantenate function, but I could do with a function to
automatically go down the list until there is no more ...

I have spreadsheet with YTD sales for approx. 1,000 parts and need to know
which items are the most important.  Basically I need an ABC report which
will tell me what parts make up 80%, 15% and 5% of the total Revenue and
assign a letter of A, B, or C respectively.  Is this ...

im using the countif function to add up all the cells in a range that
contain the Letter D the formula works but the problem im having is that if
there is on D in the range then the formula returns the 0 (zero) value how do
i get it to just leave the cell blank ??? ps ive tries ...

We have an external workbook in 97-03 mode, which when we save & open brings
up a spreadsheet, labeled NoMacros, which says "if you are reading this, you
don't have macros enabled.."  from here, you can choose Security Warning
Options>Enable this content, however this just brings ...

when I add color ro a row or/and columns the guidlines disap4ear - How do I
ge them to show up over the color?  On the spreadsheet that I haven't
colored, they are fine,

I am using Excel 2007.  I have it looking at dates and a couple requirments
in the formula.  N$1 is my date of 01/03/2008.  The change details tab lists
all of the records.  When I use this formula for a monthly report (using date
above January, 2008), it pulls the data correctly ...

I am trying to get a text response within a multiple IFF statement.  
Basically, if the value in a cell is between 6 and 9  I want the formula to
return "drier than normal"
Between 10-14, "normal" 15-18 "wetter than normal.

Hello Excel Experts,
Looking for a formula for ColumnB/Sheet1 that will match a unique identifier
in the corresponding row in ColumnA/Sheet1 to the same identifier somewhere
in ColumnB/Sheet2 and then return the corresponding row value in

I have a worksheet where the user enters the month they are interested in
the data for from a drop-down box A2. I then had a HLOOKUP to find the value
from the column for that month. This worked fine. The problem is, each month
is now going to have 2 columns under it (one for ...

I have a commission base of £40000 to £80000 I have tried to put a statement
together but end up with negative or positive valves if go above or below
range
eg

I have a two-column worksheet containing the following data; column A
(Category) contains 12 text values and column B (Markup) contains 12 related
text values.  This table resides on a separate worksheet named "Rates".  My
main worksheet, named "Data", contains several thousand ...

Why does my Excel spreadsheet open in an email format?

Would like equation that says if A1 to A10 has 400 in it, the change 400 to
"James"
Could someone please help me.