I can restrict data entry to unique entries only in the range E7 to E500
using data validation:
=IF(COUNTIF($E$7:$E$500,E7)=1
However unless I lock down sheet to stop copying and pasting this quickly

Hi, all friends
Now i want to chart the stock and line(move average line) in a chart.
But in excel, the stock chart and the line chart are separated
Can you give a better solution?

I have some data that looks like this (unlikely that it's going to translate
well the way it's pasted, but you probably get the idea):
    5/23-5/30    5/30-6/7    6/7-6/13    6/13-6/26    6/26-7/18    7/18-7/31
NVM    0%    0%    3%    0%    0%    0%

I posted this before but not sure if I expressed it correctly.
I need to chart about 5 series each having months in the X axis.  Each also
has its own Y number ranges.  
Example:

A 2 part question:-
1] Is it possible for Excel to link page numbers to a Word document ie Word
document is 5 pages long & Excel starts page number at 6 (or whatever the
last page of the Word document is - needs to be flexible)

I have duplicate formulas through 5000 rows, columns A - F .
I would like to convert the row formulas to values if a result in column F
is present.
is there a simple macro which will

Why is qw in a cell and cannot be removed?

I have one user using a standard file (Excel 2003) that they can make changes
then save, but if they then make further changes it will  not save under that
or any other file name, any idea's why?

In Excel why does the sum of these three cells come to zero?
-1000000000000000000
1
1000000000000000000

I have a list of names and I want to randomly sort them and extract one of
the sorted names in order, then randomise again, select, randomise, select
etc...  i.e.  Say I have 4 names:
Fred

Ihave exported a table to excel from access. There is a column which looks
like this "18/12", "23/10" etc. It is defined as text in access and i can't
change that. When i exported it in excel, it kept this format but when i try
to change it (format cells-date-some format(e.q. ...

I am exporting information from GP Dynamics into EXCEL and then creating a
PIVOT TABLE.  The export happens several times a month and I am trying to
automate creation of two PIVOT TABLES.
I am inserting a "NET" column for sales.

I have Excel 2002 and a sneaking suspiscion that I have been dooped.  Upon
opening a new workbook and typing in any cell on the sheet, a message
automatically appears when I finish the word and hit the space bar.  The
message is a personal joke from a friend, but I don't know how ...

I know what they mean>>PERMUTATION AND COMBINATION
There is a lot of question about it in discussion group but no answer for
this simple question ( not even in www.mathworld.com... or other websides).
Can someone just offer a simple answer to this problem ?:

I get a file every month that contains 2500 social security numbers.  The
dashes are in the right place but some of the leading zero's are always
missing in that particular column.  Instead of trying to add these manually,
is there something I can do instead??