I have a worksheet with 2 columns.
Col1 is "Name"
Col2 is a number
There are many duplicates in column 1.  I would llike to combine those

I have a drop down list from data validation.
I need it to be specific numbers based on another cell.
Like if a1=12
then the list is 1,2,3

In Windows 98, I could search within "all files" and AUTOLISP files would be
included in a search for text content in a folder.  But now, in Windows XP
pro, it will only look for text content within TXT files.  So why not LSP?

When trying to link a worksheet to a Word document, Excel
only gives me 10 of the 15 rows in the worksheet.
I'm using the insert, object commands in Word. (Or should
this be a Word post?)

i have a table of 100's of figures that are all in text, ie:
12 34 45 56 67 78
56 78 23 78 34 67
23 89 45 78 87 21

I am new to excel and I am trying to learn how to create
a scorecard.  For example, I want the end user to be able
to simply type a "1" in a cell but I want it to calculate
it as a certain %.  So that the subsequent cell can

I am trying to sum a column that is filtered, but only sum those values
where an adjacent column is a particular value.  Is this possible?
Thanks
Ben

I'm pretty new to this game, so here goes.....
If I enter a date in cell A1, say 24/11/03.... I then want B1 to tel
me what month that is (i.e November-03)
But I also want excel to automatically complete cells C1-M1 with th

I have a sheet with inventory, col (A) material Col (B)
description and Col (C) Part Number.
I also have a sheet that does a Bill Of Materials.
It gives material and description. I need to lookup the

I have a huge legacy database that has asterisks in front of thousand
of items.  I am trying to get rid of them so that my sort will wor
properly and find that since the * is a wild card I can't do it.
any ideas?? (I KNOW there's gotta be a way but can't think of it at th

how can I unprotect a sheet that I forget password.
thanks

How do I reference information in a drop down menu to a row of data?
And then once that row is referenced, how do I interpolate between tw
data points.  For example, I want to choose a model number from a dro
down menu to reference a row of box volumes associated with the mode

I have a french excel at work and it seems that Excel doesn't know what
"SUM" is.... I have to write "SOMME", neither does it take "False", but it
takes "faux"... I searched for an option where it would support the english
syntaxe and function grammar, but didn't find it.  Is there ...

We have a phone list that I think needs some improvement.  The perso
that maintains the company phone list and sends it via email is no
very proficient in excel.  This leads to many lists that need to b
resent to everybody twice or three times every month because of errors

Where can I purchase a copy of Microsoft Excel 2002 or the entire 2002
Office Suite?