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

A

Ajesh

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?
 
R

Richard Buttrey

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?
Click to expand...

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
__________________________
 
Top