Eliminating data repitition

Hi all.

I am working on creating a worksheet that keeps track of files and folders
that need to be routed. The files all have a number specific to a folder,
and so it makes sense for that to be the basis for orginization.

To save a lot of time trying to find folders that are jumbled together, I
wanted to find a way for Excel to alert me whenever a duplicate file number
is entered in a column. That way, I know when I can paper clip everything
together when it comes time to file, and I don't need to find the same folder
five times. I bet there is something with data verification I could do, but
I havn't found anything that works. If you know any way to do this, could
you post a tip for a poor newbie? Thanks!

Graham

You can do it with Validation. Debra Dalgleish has an example on her site:

http://www.contextures.com/xlDataVal07.html#Unique

HTH
Jason
Atlanta, GA

"Graham" wrote:

> Hi all.
>
> I am working on creating a worksheet that keeps track of files and folders
> that need to be routed. The files all have a number specific to a folder,
> and so it makes sense for that to be the basis for orginization.
>
> To save a lot of time trying to find folders that are jumbled together, I
> wanted to find a way for Excel to alert me whenever a duplicate file number
> is entered in a column. That way, I know when I can paper clip everything
> together when it comes time to file, and I don't need to find the same folder
> five times. I bet there is something with data verification I could do, but
> I havn't found anything that works. If you know any way to do this, could
> you post a tip for a poor newbie? Thanks!
>
> Graham