Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Preventing Duplication
Well I think it shouldn't be a big prob but the thing is that i dont know the solution... below is the example of sheet: ...........*A......................... B....................C* *1*.....Customer...........Product............Orde r # *2*.....ABC Co..............MS Excel...........99004 *3*.....DEF Co...............MS Word...........99001 *4*.....GHI Co...............MS Access.........99003 ... ... *15*.....JKL Co..............MS Excel............99005 The thing is that Col C is containing order no. unsorted and are manually inserted because of which the risk of Duplications come into play. Now lets say I entered the order no. 99003 (which is also in C4) in Cell C9 by mistake. Is it possible that Excel can change color of contents of both cell i.e. C4 and C9 to Red ? Or Is it possible to show the repeated entry in cell C16 ? Or Is it possible to get alert pop-up or something alerting if i am trying to enter the no which is already registered? -- irresistible007 ------------------------------------------------------------------------ irresistible007's Profile: http://www.hightechtalks.com/m63 View this thread: http://www.hightechtalks.com/t2272756 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
prevent duplication | Excel Discussion (Misc queries) | |||
Preventing Duplicate Cells | Excel Discussion (Misc queries) | |||
Sheet Duplication | Excel Worksheet Functions | |||
Preventing cell contents from printing | Excel Discussion (Misc queries) | |||
Preventing Duplicate Entries in rows | Excel Worksheet Functions |