|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
How to be noticed/to avoid equal values in a colum
See
http://cpearson.com/excel/NoDupEntry.htm
In article ,
Irene wrote:
Hi!
I am working on a excel sheet that has a long colum with string values.
I don't want the colum to contain any equal values.
When I write new string values to the colum sometimes I am allerted if
the value already excist (as I start writing the complete string appear
with what is left marked in black). This is good because then I know if
the value already excist in the colum and I don't retype it.
However, I am not always allerted and then I end up writing the same
value several times.
Does anyone know how I can deal with this problem as I dont want the
colun to contain any equal values? Thank you for all help.
Irene
|