| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I flag up duplicate data entry in an excel spreadsheet?
ah ok will give it a shot. Thanks
"T. Valko" wrote: You can use conditional formatting to highlight the customer name if their last order/contact (?) date is within 2 months of todays date. But, you need to give use some detailed info of where this info is. -- Biff Microsoft Excel MVP "laulea1" wrote in message ... I have a spreadsheet made up of customer addresses and would like to flag up if we have had dealings with a customer in a 2 month period without having to search and find every time I have to enter data. Any idea if there is a simple way to do this? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can excel tell me if i duplicate an entry | Excel Discussion (Misc queries) | |||
| identify duplicate data upon entry of that data | Excel Discussion (Misc queries) | |||
| Cell in Excel spreadsheet will not accept entry of specific data v | Excel Worksheet Functions | |||
| identify duplicate data in excel spreadsheet | Excel Discussion (Misc queries) | |||
| Data validation to prevent duplicate entry. | Excel Discussion (Misc queries) | |||
Threaded Mode
