Is it possible to write a function using 2 logical tests that both have to be
passed in order to return a TRUE value? If so, how is this written?

I have filtered a column called Programs.  When I open the filter to view the
programs it isn't capturing all of them in the column.  I have retyped the
programs that are missing, and still it won't show.
Any ideas or suggestions?

I need to set up a formula that will allow me to specify a specific
workbook and worksheet name as part of a relative reference.
I can refer to a cell on a specific sheet within a specific workbook
using:

Is there a function in Excel to display the Worksheet Name in a cell?

I am looking for the formula that would help me get an average of cells that
have sum formulas. Some of the cells are blank due to no data being entered
in the sum cells. It is a monthly tally sheet so instead of getting the
average for May 1st thru May 13th, I am getting the ...

Is there an equivelant lookup function in Excel 2007 that doesn't care about
the order of the item it's looking up.  Example:  I want to look up "eggs" in
column 1 of a table and once I know which row that is, lookup the price from
column "unit price".  However, I have all my ...

I want to know how a web application can be called and executed without a
browser being shown.
Scenario:
I want to call a defect tracking tool from an excel "cell" and I want to

Hi
I have developed some code for Excel application through which i am going to
create an excel appliaction and open a workbook by name "ABC.xls" and insert
a value of 500 in sheet by name "sheet1" in the cell(10,10). Now my

Does anyone have any suggestions on how to remove duplicated items from a list?
For example, there is a list of number under column A, and I would like to
remove any duplicated items and lists it under column B.
Does anyone have any suggestions?

need help on how to refer to other excel file using a formula. data to be
filled in B file will be based in A file..
example:
A file contains the following:

I have a few excel files in a folder.These files interlink to each other.I am
planning to rename all files in folder & ensure the linkage formula also
updated as per new name. any suggestions?

I would need help on the following question:
How can i, create a macro to associate with a buton on a excel sheet, so
that every time i push it it sum one fixed value to a specific cell.
Increasing that cell value every time it is pushed.

I'm trying to create a button that when pressed it sends an email to a
specific email address.
That is...
Button 1 pressed send current worksheet to address 123@4567.com

I'm having trouble using a sum formula based on the conditions.  I've spent
the last few hours trying multiple formulas that have been suggested on here
but still can't get it!
In the below data I'm trying to sum Column C when Column A starts with 'E'

I am exporting a report from Quickbooks Point of Sale Pro 5.0 to Excel 2000
and trying to create a "sum of"  calculation.  The sum always comes to 0.  It
is not registering the numbers as a number.  However, if I do not use the
"sum of" button, and just put + (plus sign) and ...