i maintain DB of URLs in Excel. how can i avoid duplicate entry?
 

i use windows xp. i am maintaining a database of urls in excel. i want to
avoid re entering the urls. is there a way i can do it?

i maintain DB of URLs in Excel. how can i avoid duplicate entry?
 

On Tue, 4 Apr 2006 07:14:01 -0700, Ajesh
wrote:

i use windows xp. i am maintaining a database of urls in excel. i want to
avoid re entering the urls. is there a way i can do it?

One way would be to temporarily put your new URL in a test cell, then
in another cell have a VLOOKUP.

i.e. =VLOOKUP(testcell,yourexistingURLrange,1,false)

If the Vlookup evaluates to #N/A it means the new test URL does not
exist in your data, so add it to your list.

You could get really smart and run this with a small VBA macro,
prompting for the new URL, testing it as above and adding it to your
list if appropriate.

HTH

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________