I need to calculate the (for example) first Wednesday of every month, given
the date April 5, 2006 is entered in a cell.  How do I calculate the new
date, the first Wednesday in May (May 3, 2006)?    

I have a single page summary report that obtains specific information from a
pivot table.  I would like to bring back company leaders within designated
groups found by a lookup table.  The company and branch leaders are always
dynamic. Since the company leader data is is always ...

I have a large file laid out as follows below.  
Column A     Column B
SSN1    Name1
SSN1    Address1

I have a list of ten names and need to pull one randomly.  Is there a way
that I can put a number 1-10 in a cell and it would randomly return one of
the ten names?  as an example if I put the number 2 in the cell it would
populate the cell next to it with Name 1.   If I cleared ...

How I can write this function for one cell
=IF(O9<-2%;1); IF(-1%<O9<-2%;2); IF(-1%<O9<2%;3); IF(2%<O9<6%;4); IF(O9>6%;5)
More in detail I have to compare a value with 5 criteria and put the
relevant number from 1 to 5

=AND(COUNTIF(A1:A5,"HM"))*(COUNTIF(B1:B5,"5"))
Trying to calculate the following:
A       B
1   HM    5

Does anybody know why XNPV appears not to accept negative rates?
e.g. using the example in the Excel 2003 help: (i.e. amounts = -10000,
2750, 4250, 3250, 2750, dates = 01 Jan 2008, 01 Mar 2008, 30 Oct 2008,
15 Feb 2009, 01 Apr 2009) returns #NUM! for rates 0 or below. That is

a1,a3,a5..........  =a1+a3+a5.............
can i use a formula that calculate every next row.
Thanks in advance,
Aarif

I am trying to discover a formula/function that will allow me to do the
following!
my problem is this:
x = 100mm

I RECENTLY UPGRADED FROM EXCEL 2000 TO EXCEL 2003.  IN EXCEL 2000, THERE WAS
AN ENGINEERING FUNCTION CATAGORY AND IN THIS CATAGORY THERE WAS AN
INTERPOLATION FUNCTION.  I USE THIS FUNCTION ALL THE TIME AND WHEN I TRIED TO
USE IT IN EXCEL 2003, IT SAID IT WAS UNDEFINED.  I DO NOT ...

Is there any way of building a search table on excel, so I can search
large spreadsheet e.g. the search table is in sheet1 and the dat
spreadsheet is in sheet2. Both sheets are linked. With in the searc
table on sheet1 I want to have several search fields (Filters) thes

Is there a function that will create an array based on values in two
other cells?
Give:
A1 = 3

Pls correct me on this formula: something wrong on opening file.
Sub openreport()
myPWD = Application.InputBox("Password Protected! Please Enter Authorized
Password to Continue!")

in sheet SOURCE in a column A I have 268 nubers, which have dependents
to the sheet CODE. In sheet SOURCE in column B I need to get
information, what are dependents of the value in column A (their
addresses). I tried to use some info functions, but it was not good...

I want to create a heirarchial drop down lists in excel.How do I do it.
For Ex-
Column A has the following drop down elements- Animals,Birds,Continents
Column B should have the following drop down elements depending upon the