How can I delete the "Insert Function Dialog Box" (dialog box only) in EXCEL
2003?  I do need Insert Function, but know how to enter formulas I need.  
Each time I hit the Insert Function icon in the formula bar, the dialog box
appears.  When I close the dialog box, the formula ...

Hello, I have 8 columns of data that extends to over 1000 rows. One column
contains different patterns. I would like to copy the data in the cells of
two columns on the same row for all the instances of the same pattern to
another worksheet. I would then have a worksheet for each ...

I have recently installed Office 2007. I have noticed an incompatibility with
a number of Excel spreadsheets that I have created in Excel 2000, 2003. The
issue is with the DATEVALUE() function. It appears that in earlier versions
Excel accepted text in the following format ...

using VB I would like to save a file using the date that is cel d2.
I want to save it in following format "reg_MMDDYY".xls
Does anyone know how this can be done?
I used to be able to do it in Lotus but have been bashing my mind for the

Hello Guys and Girls,
A have a issue with named ranges. I have a named range "TestRange", with the
values "OK", "NOK".
I'm trying to test a cell against this range, so I am using something like

I WOULD LIKE TO HAVE THE LINE (ROW) NUMBERS THAT APEAR ON LEFT SIDE TO BE
MIRRORED ON THE RIGHT SIDE OF THE SPREASDSHEET AS WELL; IS THERE A WAY TO DO
THIS?

Have spreadsheet of key dates & am looking to set up an alarm in advance of
date being reached, say 72 hours before stipulated date - is this possible
w/out knowledge of VBA

Hi I have a big dataset and each item needs to be classified as either
"active" or "inactive".  By default lines are inactive, unless they are
contained within a subset that is listed in a separate database, where
individual lines are classified active/inactive, in which case ...

XP Pro/Office 2003 PRO
Is there a limit on the number of characters that can be used in the
criteria section of a SUMIF()/COUNTIF() function?
Columns A & B consists of strings with a length of 30 to 50 characters.

for simplicity, say I have the following in one spreadsheet in a
workbook:
first      last     weight
j           red        65

I am sure there is a straightforward way to do this, but somehow I  can't
seem to get it to work.  I want to sum multiple cells in a 2d array, based
off the x and y values in a given column.  As a simplified example, use the
data:

Can someone explain in simple terms, what the { } do to a function.
Thanks

Does anyone know how (when using vlookup) to only show a values if it
exists.
Example
Table looks like this

Greetings,
I have over 400 rows of data where Column 1 is text (project titles) and
Column 2 is a start date and Column 3 is an end date.  In each of the date
columns, there are duplications.

I have a worksheet called "master"  that includes a column called
"identifier" which is an ID name. There are several occurrences of each
"identifier" value in the column. I have another worksheet called "dams" that
contains the same "identifier" column, but with only one ...