Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need a warning when a duplicate appears in a column
Hello good people!
Anyone who can help me with following problem: I need warning to pop up when the user of a sheet is trying to put/write the same letter, number or word in two different cells in a column. I must mention that the cells in use are already validated, using a list validation. Anyone? :) Best regards ELFrodo |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need a warning when a duplicate appears in a column
You could use Conditional Formatting to color both cells when a duplicate is
entered. Select A1:A50 and FormatCellsCFFormula is: =COUNTIF($A$1:$A$50,A1)1 Format to a nice bright red. To have a warning "pop up" would require VBA code or Data Validation which you have used already. If you did use DV you would change the formula to =COUNTIF($A$1:$A$50,A1)=1 Gord Dibben MS Excel MVP On Sun, 11 Feb 2007 15:41:00 -0800, ElFrodo wrote: Hello good people! Anyone who can help me with following problem: I need warning to pop up when the user of a sheet is trying to put/write the same letter, number or word in two different cells in a column. I must mention that the cells in use are already validated, using a list validation. Anyone? :) Best regards ELFrodo |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need a warning when a duplicate appears in a column
Thanks Gord Dibben.
Think it might work:) Have a good day! ElFrodo "Gord Dibben" wrote: You could use Conditional Formatting to color both cells when a duplicate is entered. Select A1:A50 and FormatCellsCFFormula is: =COUNTIF($A$1:$A$50,A1)1 Format to a nice bright red. To have a warning "pop up" would require VBA code or Data Validation which you have used already. If you did use DV you would change the formula to =COUNTIF($A$1:$A$50,A1)=1 Gord Dibben MS Excel MVP On Sun, 11 Feb 2007 15:41:00 -0800, ElFrodo wrote: Hello good people! Anyone who can help me with following problem: I need warning to pop up when the user of a sheet is trying to put/write the same letter, number or word in two different cells in a column. I must mention that the cells in use are already validated, using a list validation. Anyone? :) Best regards ELFrodo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup function/sum function | Excel Discussion (Misc queries) | |||
How do I combine spreadsheets and documents in one file? | Excel Discussion (Misc queries) | |||
Duplicate Value warning | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |