I have a very large mixed product list with various different choices
available to all products. The data has been carefully added over a long
period of time and is accurate.
I have created another worksheet using columns that extract any relavant

Is there a way that the contents of a cell can be displayed in a pop-up
window when you hover the mouse pointer over it, ie. the same way that
comments are displayed.
The pop-up required for my purposes will include text only and will not

I have a named range called "Range_1" which is set as:
=OFFSET(Total!$E$3,0,('Graph Data'!$J$2-1)*5+'Graph
Data'!$I$2-1,COUNTA(Total!$B:$B)-1,1)
It works fine, and essentially keeps the named range to the length of the

I downloaded from a data base that has the Zip Code +4  (00000+0000) in a
single field. I have hundreds of line in this worksheet.  How do I remove the
+0000 values inside all of the cells in the column?

What to do to indicate the first highest score for each person?
Here's the example:
ID    score    score used
a    1

Apologies if the answer to this question is in some 'obvious' place --
I've not found it if it is!
Is there a provision (other than using some arbitrary cell swomewhere)
for creating (one or more) intermediate results to be used in

I would like to create a formula where I can copy a date entered in the last
cell of a row on the same spreadsheet.
I would like to insert the formula starting in C2.  For example, in row 2 of
my spreadsheet, if cell H2 (last one) has a date, copy the date to C2.  But

I have a budget template saved on my computer at work it worked fine
yesterday and I emailed it to my house.  The one I emailed works fine.  I go
back today to the one saved at work and none of the formulas will calculate
by them selves.  If I change something I have to click the ...

I need to remove nonprinting characters that appear from an imported Outlook
contacts spreadsheet.  Find and replace is not helpful and I am not sure how
to do this with formulas and maintain the values.  Any ideas.

Here is a data:
Month completed          Year completed          Past Due?          Name
7                                 2007                         Y            
        Joe

Hello Excel gurus!
I have a cell (Say A1) that I'm trying to conditionally format when the
adjacent cell (say A2)is between but not equal to 0 and 100 percent (I'm
trying to show when something is in progress, but not completed). I don't

I am looking for a sumproduct formula that counts how many Titles in a sheet
are Backordered and have Availability date between D1 and D2.
The data resides in two separate sheets:
Sheet1

I'm trying to grab information from another worksheet but when the line I'm
referencing on the other worksheet isn't available it returns the value #N/A,
which is fine but that's not what I was to display, I just want an empty cell
when it cannot find that info on the other ...

For example:
I had a worksheet with lowercase verbage in several cells.  I wanted to have
the verbage written in all uppercase, so I used the "Upper" formula to
convert it.  But now I would like to change it to the absolute verbage rather

How can I use formula and format as it is, in the next rows?