Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inputting duplicate data alert MS Excel 2003
hi In MS Excel 2003 I am writing a list where I regularly have to input data
which I have already input but instead of having to remove all duplicate data after finishing (using advanced filter) I would save massive amounts of time if there is some kind of alert as soon as I begin inputting duplicate data (e.g if I type 76 Main Street is there any way I could be alerted that I have already typed that address so I do not type the whole record again which takes alot of time)? Thanx |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inputting duplicate data alert MS Excel 2003
Chip Pearson has lots of techniques to work with duplicates:
http://www.cpearson.com/excel/duplicat.htm qubit wrote: hi In MS Excel 2003 I am writing a list where I regularly have to input data which I have already input but instead of having to remove all duplicate data after finishing (using advanced filter) I would save massive amounts of time if there is some kind of alert as soon as I begin inputting duplicate data (e.g if I type 76 Main Street is there any way I could be alerted that I have already typed that address so I do not type the whole record again which takes alot of time)? Thanx -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inputting duplicate data alert MS Excel 2003
"qubit" wrote: hi In MS Excel 2003 I am writing a list where I regularly have to input data which I have already input but instead of having to remove all duplicate data after finishing (using advanced filter) I would save massive amounts of time if there is some kind of alert as soon as I begin inputting duplicate data (e.g if I type 76 Main Street is there any way I could be alerted that I have already typed that address so I do not type the whole record again which takes alot of time)? Thanx Never mind I checked again on web and found the answer is to select relevant cells, click data, validation, allow:custom, formula - =countif($a$1:$a$(input relevant last selected cell number here),a1)=1 and that worked excellent |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
Using Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel |