Excel 07 doing advanced filtering.  I have a column of numbers, some are
repeated, and I want to filter out unique numbers only.  So as a test,
starting in A1 and going down, I input 1,2,3,1,2,3.  Under advanced
filtering, I selected the range, a1:a6, want it copied to another ...

I'm having difficulty getting a sum of the contents of a cell that appears in
multiple worksheets in my workbook.  It returns a VALUE error.  It is:
    =SUM(Master!Q2:'Week 1'!Q2)
where Master and Week 1 are the sheet names (with a Week 2 in between them).

I was hoping someone could help me with this... I have used it before - but
obviosuly did not write the formula myself!-
I wanted to insert a column which automatically fills in a reference code
for new purchase orders to be sent out.

Hello,
I want to nest more than 7 nested functions (actually I woould like to do
about 14 or more.  Is this possible?
I have listed a sample of what I have to date but cannot seem to get any

I have two columns - 'Key' (text, col A) and 'Forecast' (number, col B).
I have several rows for each 'Key' value, but the number of rows *varies*.
How do I (in one function in col C) calculate the maximum value for each
'Key'?

I have a spreadsheet with multiple worksheets. I am trying to get specific
data from a named range (LOANS) in one of the sheets into a cell on a
different sheet. My main sheet (named DATA)contains info such as Name, Acct,
LoanBal, and NetBal and lists all customers. The other ...

I have a worksheet that I want to try and eliminate manual activity.  To
simplify the question, assume I have three cells A1,B1 and C1.  If the value
in C1 is X then I want to place the value of B1 in A1.  If the value in C1 is
not X I want to leave the value in A1 alone.  

Good Morning,
I have an expression =SUMPRODUCT((MONTH('Raw Data 2008'!A2:A1528)=1)*('Raw
Data 2008'!B2:B1528<>"XIAPPLXRP110")) in which I would like to add another
criteria.

I think this might be frequent question but I didn't find it in my search.
If you can point me to another relevant topic, it's just as fine.
My question is, how can I interpret a sequence of cells as an array for
functions that require an array.

I have a new workbook and an old workbook with contact information.  How can
I merge the two workbooks removing duplicate entries?

I have a coulumn of data that with several rows of the same data and then the
data changes for several other rows and so on down the sheet. I need to be
able to selcet the column and insert a row between where the data changes.
Almost like doing a subtotal but just inserting a ...

In Excel 2007 I want to copy and paste special, both values and formats, from
a pivot table into a new worksheet.  The values copy and the values are
formatted, but the sytles do not copy overs.  Any ideas?

Wanted to show formula conatains in the cell into another sheet or file

I am doing a payroll program and want to have Y-T-D totals. I use the
following formula and get the results I want on the date that I process the
checks. (I have a seperate cell for each payday of the year):
=IF(TODAY()=DATE(2008,1,25),D13,0)

I am running some code that clears all the errors (#DIV/0!) in certain
columns. The code I am using is shown below:
Columns("AQ:BC").Select
   Selection.SpecialCells(xlCellTypeFormulas, 16).Select