I need to have Excel search a column of street address, street number and
name and locate any duplicates.  Is it possible?

I have two lists in separate files.  They look something like this:
Month    Product    Qty    Price    Total
Jan    Apples    54    3    162
Jan    Oranges    21    3    63

How can I express the following within a function?
begins with
contains
ends with

I am trying to get a list of the selected add-in in an application, I have
tried:
For Each w in aAplication.Workbooks
     debug.print w.Name

I have an excel spreadsheet to track Work Order numbers (Column A). I want to
be able to go to the next available cell and type in a work order number and
be able to get a message back if that work order already exists.... Is there
any way to do that?

I have a sheet with specific numbers. On another sheet, the user would input
a value. I like excel to find that number or the closest number then return
the value in row/column X.
Example:

Good morning
I have 2 cells I need to compare:
- one cell is the baseline (assume $100)
- the other cell is the real cost obtained after a calculation from other

How do I change data format so that vlookup will recognize that it is a match
for the desired value?  I've tried copy, paste special, custom formatting,
etc. but when I select a particular cell, the value that appears on the
formula bar is still in the wrong format, even though ...

       one more problem, I have random numbers in column A, now in
column B I need the numbers that are divisible by 4 in ascending order
in consequtive rows. could any body help me to solve this.
Thanks and Regards

I have a workbook with 50+ sheets and each tab is named.  I need
to create a new sheet in the same workbook that will pick of the same
cell from each of the 50+ sheets and put them in a column on the new
sheet.  In tab order, left to right.

I'm having problems locking a specific set of cells in my
spreadsheet.  The issue is mainly that I will specify what cells I
want locked and what users are allowed to change, but Excel leaves
some extra cells unlocked for no reason that I can discern.  What am I

Hello. this formula
=SUMPRODUCT((MONTH('G Codes'!D6:D300)=MONTH(E5))*('G Codes'!
C6:C300=C103)*('G Codes'!J6:J300))
sums the amounts in column J of 'G Codes' if

Excel 2000 - I'm trying to help a co-worker with this, but I'm only a bit
more proficient than she is.  She has a very large worksheet and would like
to copy sections of it to individual sheets (in the same workbook), so that
she can work on the smaller sheets - easier to read, ...

I have 3 columns.
Columns;
A = ID
B = status

IF( 'E:\file\[1.xls]Sheet1'!$A$1 = 1 THEN
{ / Processing following code
Workbooks.Open Filename:="E:\file\1.xls", UpdateLinks:=3
Workbooks("1.xls").Close savechanges:=True