Damn! That's what I thought you were going to say
OK, the official answer is "It can't be done", because doing it requires
VBA, which won't return until Office 2011.
Have a look at the Excel Help topic "Add, delete, or find data in a list".
That may come close enough for your purposes.
Or, you can fudge it using VLOOKUP. However: it won't do exactly what you
want.
If you construct a sheet in which you assign an "input area", you can then
type the email address into that.
You need three columns: The Input area (in a single cell), the "Flag" cell
(perhaps the cell to the right of it) and the "Addresses" column (which must
be to the right of that.
Study the help and examples for VLOOKUP in the Excel Help, it's quite
complex.
You then use the entry in the input cell in a VLOOKUP that scans the column
containing the existing addresses. If it finds a match, it colours the Flag
cell red, which will alert you to the fact that you already have the address
you are about to enter.
You could also use a simple Conditional Format in each cell of the Existing
Addresses column to turn the cell green if that entry matches the entry in
the input cell.
So if you enter an existing email address, you get a red flag cell to say
"already got it" and if you scroll the list, the matching address will have
gone green.
Without active code, that's about as close as you can come.
Let me know if you need more help.
Sorry,
I have Microsoft Excel 08 for mac: Version 12.1.0 (080409)
Operating system: Snow Leopard mac 08X version 10.6.9
Thank you kindly!
--
The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!
John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:
[email protected]