Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
How do I create a list in excel that contains external data? | Excel Discussion (Misc queries) | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |