I have about 11,000 documents listed in a worksheet that are individually
numbered, and want find duplicate entries in the worksheet. I need to create
a formula that will allow me to see ONLY the duplicates.

I'm trying to access Excel files from a Perl program using OLE.  Where can I
find the available methods and properties for Excel?
Greg

I have a VLOOKUP and some  of the results are #N/A as there is no data for
that cell. I need to sum the rows of cells, including those with #N/A (those
values would then be 0).When I try to add the results those error cells do
not let me add up the other cells with real values.

I have a user who is exporting data from a website into excel files.
When he creates a pivot table from this excel file it creates another
folder in the same directory of the excel file containing html files.
If you delete this folder and reopen the original excel file all the

Hi.  I have a nested IF statement that works just fine until the date changes
to any date including and past 1/1/2010.  The IF statement is:
=IF(AND($H2="A",EmployeeData!AX4<Information!$H$12),Information!$B$14,IF(AND($H2="A",EmployeeData!AX4<Information!$H$17),Information!$B$18 ...

Is there any way to make a tab take on the name of a given cell automatically?
(Ex. If 1 enter Joe in A-1 a specific tab will be named Joe)

I have a pivot table that I want to include source data from multiple
worksheets.  the fields are the same in both but the ranges are different.  I
have multiple worksheets because the numbers of rows is more then 65000
combined.

I have a situation where I want to reference multiple worksheets with the
same range. For instance I have a main SUMMARY page. And every other sheet is
called Sheet1, Sheet 2, Sheet3... Sheet 99.
SUMMARY looks like:

How do I assign a macro to a button in the Quick Access Toolbar. And run the
macro by just cliking the button and not open the macro file first.

Back Lotus 1-2-3 we could have a Macro pause with {?}.  How do you pause an
Excel macro for user input?

Hi there,
I have another question/problem which involves vlookup.  It's similar to my
last one, but with a little twist.
I have 18 Groups listed in Column F

Halfway through my final project Excel started acting weird on me. I've
restarted and re-opened Excel but it's still doing the same thing.
If I type in a number ie: 1500000 it turns it into 15000
If I type in 1,500000 it keeps it proper and displays 1,500,000

I had Office 97 running in a XP computer and Solver worked fine.  My new
Vista machine does not allow Solver, apparently.  What can I do to get this
useful feature back?  I am a home user and would prefer not to buy another
Office package.  Alan C

I have a column oof dates and times (ex. 11/19/2007 1:50:00 PM). Is there any
way to count the number of times there is an entry for the month only. In
this example the month of Nov.

It works fine within one spreadsheet but fails when I try to copy a
cell including a formula to a new excel spreadsheet and copies only
the value. Is there a way to force it to copy the formula so it
automatically applies to relative positions of cells containing