I have a data sheet (sheet1) that is updated every couple of weeks. The
column information is A) stock #; B) Description; C) Weight; D) Price; E)
Entered Date. My data sheet contains information that now contains multiple
enter dates( 200+ rows of information).

I have an equation using SUMPRODUCT on a table, and when I modify it to
include an "OR" function, it no longer works.
My original function:
=SUMPRODUCT(Table1[Column1]*ISBLANK(Table1[Column2]))

I have a sheet in a workbook where I need to select the last row containing
data.  Is there a for/next loop function where I can identify the last row,
then select data from it, or can I update two sheets simultaneously with one
input?

Somehow one of my 2007 excel spreadsheets grew virtical and horizontal
dashed lines that describe the perimiter of each page.  I have been unable
to find out how to turn them off.
Any help much appreciated.

Hi I have a column "A1" to "A300" with time data (06:19:21), how can I
subtract a half hour?  The seconds should not be relevant in the final column.
Thank you

either of these options i am open to.
i do not want the userform to open when the workbook is opened, but
rather i want it opened when the specific worksheet is activated
basically

How do I get the top column row, which contains only the column letters, and
the row number, which is the narrow column to the left of Column A, to
disappear when I print?  thanks everyone for your help.  -mlenard

Is there a way to control the size of the comment box. Currently the box
opens as about a 2 X 3 in box. I would prefer to have it open as a rectangle.
I know that can be adjusted by using the handles...but can the rectancle size
be set as a default?

I have resisted the urge to upgrade from Office XP for a while, as I never
got used to the ribbon when using a beta.  I finally made the jump after
seeing a work colleague looking quite speedy & productive with Excel 2007!
So this morning I'm doing some expenses, and with a pile ...

I all of a sudden am using Excel again, this time Excel 7 and forgot how to
do some things.
1.)  How can I expand a page to fill the printer print area?
2.)  How can I print all the worksheets on a single document?

I want to average a column of negative numbers (there are blanks) such
that I find the average of all numbers between -110 and -180.  ( So if
I have 300 numbers in my list and 40 of them are between -110 and
-180, I want the average of just those numbers.)

Help pls!

Hello, I have two rates of exhange and I want to find the mid point and
deduct 3% all in one formula.
The bank buy rate is  1.6706 (cell a1)
The bank sell rate is  1.6085 (cell a2)

I just recently upgraded to Office 2007 Professional, but my work still uses
2003, and when they send me Excel files, it keeps telling me that the cell
data is too large and gives me formulas instead of the actual text.  I know
there is a compatibility pack to view 2007 files in ...

My e-mail program inserts a name when just a few initial letters are
entered. Can Excel do this when updating a list of customers (or others)? It
would be much easier than retyping the entire name each time.
Many thanks.