| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
CATCHING DUPLICATE INFORMATION IN DIFFERENT CELLS SAME PROGRAM
I am working in excel and need to have a warning when information previously
keyed is being duplicated in the same colums. Example: column B is always ticket numbers. I want excel to warn me if while keying in column B I key the same number in a different cell. I want this restricted to certain columns not the entire workbook. |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
CATCHING DUPLICATE INFORMATION IN DIFFERENT CELLS SAME PROGRAM
Lisa
Check out Chip Pearson's site for "preventing duplicates". http://www.cpearson.com/excel/NoDupEntry.htm Gord Dibben MS Excel MVP On Thu, 20 Jul 2006 04:12:01 -0700, Lisa wrote: I am working in excel and need to have a warning when information previously keyed is being duplicated in the same colums. Example: column B is always ticket numbers. I want excel to warn me if while keying in column B I key the same number in a different cell. I want this restricted to certain columns not the entire workbook. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| a function that counts the amount of cells with information in them | Excel Discussion (Misc queries) | |||
| Not Printing the information in cells | Excel Discussion (Misc queries) | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Preventing Duplicate Cells | Excel Discussion (Misc queries) | |||
| Duplicate information | Excel Discussion (Misc queries) | |||
Linear Mode
