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 |
#2
|
|||
|
|||
Preventing Duplication
Hi!
You can do all of those things but this is your best solution: Is it possible to get alert pop-up or something alerting if i am trying to enter the no which is already registered? Select the range of cells in question. Assume that is C1:C15 Goto DataValidation In the Allow drop down select CUSTOM In the Formula box enter: =COUNTIF(C$1:C$15,C1)<=1 You can create a custom message that appears or just use the default. Click the ERROR ALERT tab and fill in the message if you want to use your own. Biff "irresistible007" wrote in message ... 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 |
Reply |
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 |