I have a spreadsheet with text which extends beyond the column width but is
still visible. However, in one row, only the amout of text that will fit into
the width of the column is displayed although the full text string shows in
the edit box. Any ideas?

I have this formula
=hlookup($a$1,sheet1!$a$21:$ap$41,1.false)
It works fine but, returns #NA if $a$1 not found.
How can I make it return "out of range"

I've been trying to do a regression analysis on data I've filtered
using autofilter. I keep getting the error message "input range
contains non-numeric data." I've used autofilter to eliminate any non-
numeric cells and I've also made sure it's formatted as a number

i am trying to add additional functionality to my Project Budget
Expendature worksheet of which some of you may have seen.
anyways, the idea is to have sumproduct calculate all items that have
the same GL code & date of which it was purchased (date of purchase)

I'm a bit new to Excel so apologies for asking about basic things.
PROBLEM ....
When I key CTRL-F I get a full screen view.
I do not want this.  I want CTRL-F to be "Find".

I need to digitally sign a couple of macros. Who is the best/cheapest source
of a digital certificate?
What are the pitfalls that I might not be aware of
I've never done it before. I know nothing about it

I have the following table:
Column A - Date. The date is only listed for line number 1, but
applies to all lines until the next date.
Column B - Line (machine) number

I am using VLOOKUP to calculate costs of overfill using a table of
data
I forgot to add in another type of unit that I needed to calculate so
created a 7th element to the table.

Hi,
Can someone please explain "Fcrit" to me in layman's terms. I have seet it
used in a formula that seems to look up a name in a column - the formula is
=IF(ISERROR(fcrit(C:C)),"",RIGHT(fcrit(C:C),(LEN(fcrit(C:C))-1)))

Column B consists of Brand names (each brand has numerous products)
Column C consists of Product names (over 500 products)
Coumns D to CG (row 1) consist of months going back a few years.
The data from D2:CG539 consists of the rank of each brand for each

All,
I was getting strange results in my spreadsheet.  Some columns or rows
were adding fine, others were returning zero as the result (when that
was incorrect).

Hi. I have in column A the numbers 1- 26, in column B the letters A- Z. I'm
trying to create a formula wherein, when I type a number 1- 26 in C, the
corresponding letter will appear in D (if I type '1', 'A' will appear, if I
type '2', 'B' will appear, and so on). I was nesting a ...

I recently installed Office 2007 Enterprise Edition on my laptop.  During
the installation it prompted me if I would like to upgrade or to remove all
the previous versions (Office 2003).  I opted to remove and do a custom
install so that I could install some add-ins to some of ...

I have a list of numbers in rows D7:D28, and another list of numbers in
E7:E28
I then add this formula to rows G14:G24 (the placement is actually
irrelevant)

Good afternoon Bob:
In reference to your QA: (Which sheet was the active sheet when you
right-clicked on the tab? It should have been Data Sheet).
Yes, I did as you said, but I am not sure I placed the text string in the