Interpretation for:
=INDEX(F1:F100,MATCH(1,(A1:A100="Custname")*(D1:D100="State"),0)) Enter with
Ctrl+Shift+Enter
Dear All,

Please look the below example and tell me any formula that can be used to
fulfil my requirement.
Example:
9:01:55     ABC    Yes

Dear sirs,
Kindly advice how can we convert PDF file into ms excel
I tried many times copy past option but PDF file created through oracle
version is 2.0 in this version of oracle I can’t past data in excel same as

There is an option with Pivot tables (In Layout and Format) to show "0" in
the "For empty cells to show:" field
However - I find that if all the fields are empty, then "0" is not shown. ie
a "0" will only appear in any of the blank field only if ,at least, one of

Sometimes when I want to reference the value in a cell from another worksheet
I get this in the cell ='EE-4201-Mp-11'!D3.  It is showing the worksheet and
the cell and not the value in that cell.
What is causing this.  It does not do it all the time.

I have a set of forms that I have developed in Excel, They print correctly on
my PC but when others try to print the page layouts are different.  THe
others have the same printers and print drivers that I do.   How can you make
the page setups transfer with the file to others?

=(SUMPRODUCT(--($B$5:$B$200=$B5),--($L$5:$L$200="Sell"),--(H5<H$5:H$200))+1)
The above isn't working
Colum B = labels like "Apples, Bannanas,"
Column L = lables like "Hold" or "Sell"

Col A               Col B        Col C
apples             -1              
apples              3
apples              1                 4

-- I have a question involving exceeding the amount of IF statements.
Cell A1 has drop down list of 100 choices, the user selects one
Cell B1 has another drop down list of 100 choices, of which the user selects
one

I have a .xls file that is very important and that I don't want anyone
messing with. However, my people need this .xls file for a Borland Delphi
application that interfaces with Excel via a TExcelApplication class. So I
have to put this Excel file on everyones' machines so my ...

I have a spreadsheet which returns live market prices.  From time to
time I receive an error as the price is no available, the error I
receive is #N/A N.A..
I would like to display a warning message to the users that a price is

I have a data set and have created pivot tables using this data set.  In my
data set I have a column for comments so that I may write text.  I have
created a pivot table and incorported my "comments" column in the pivot table
as a column.  However in my pivot table the cells in ...

i set up a macro below to filter out a column (dates) that are more than
cell F2, where cell F2 is also a date. But it just doesn't work. Why? Thanks!
Sub Filter_BS()
   Selection.AutoFilter Field:=7, Criteria1:=">" & Range("f2"),

Excel 2007 - I can easily change the source data in Excel 2003..Click on
Chart, Source Data, Series, etc... but now I have moved to Excel 2007 and
need an easy way to expand or revise a chart and I can't seem to get it.  Any
help Appreciated.

Need Excel formula to merge one list of phone numbers with another...like I
have a voter listing and a list of voters in 2006 and I want to create a
column that indicates whether each voter...voted in 2006?