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