Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I want to be prompted for an entry that already exists in excel
I use Excel to maintain an animal breeding program. I want to be prompted
when a animal number is entered that already exists. This would be handy for name and address databases too. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
I want to be prompted for an entry that already exists in excel
Hi Jade,
I want to be prompted when a animal number is entered that already exists. Use Data, validation for this. - select the range that will get the numbers (lets say the entire Column A) - Choose Data, validation - Click the dropdown box and select "Custom" - enter this formula: =COUNTIF(A1:$A$1,A1)<2 (notice the dollar signs!) Regards, Jan Karel Pieterse Excel MVP www.jkp-ads.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prompted data entry | Excel Discussion (Misc queries) | |||
how to sum a column only when an entry exists in a different colum | Excel Discussion (Misc queries) | |||
how do I update links without being prompted in Excel? | Excel Discussion (Misc queries) | |||
Exiting Excel without being prompted | Excel Programming | |||
Exiting Excel without being prompted | Excel Programming |