Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Preventing duplicate data
Hello Can anyone please help me?! I have found a formula that is meant to prevent duplicate data entry, but it doesn't seem to work properly! I have a large spreadsheet with values in column A. I don't want duplicate values entered anywhere in column A. Eg - If I have entered 1234-10 in cell A7 and then try to enter the same value in cell A67, I want to be told that it is a duplicate. I thought I found a solution which was using Data, Validation, Custom and the formula - =COUNTIF($A$6:$A$3000,A6)=1 BTW - My spreadsheet goes up to row 3000!! However, this is now telling me that EVERY value I enter is a duplicate even if it isn't already there. PLEASE HELP ME!!!!! Thanks T -- tillytee1 ------------------------------------------------------------------------ tillytee1's Profile: http://www.excelforum.com/member.php...o&userid=27688 View this thread: http://www.excelforum.com/showthread...hreadid=524300 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Preventing duplicate data
Works by me!
HTH -- AP "tillytee1" a écrit dans le message de ... Hello Can anyone please help me?! I have found a formula that is meant to prevent duplicate data entry, but it doesn't seem to work properly! I have a large spreadsheet with values in column A. I don't want duplicate values entered anywhere in column A. Eg - If I have entered 1234-10 in cell A7 and then try to enter the same value in cell A67, I want to be told that it is a duplicate. I thought I found a solution which was using Data, Validation, Custom and the formula - =COUNTIF($A$6:$A$3000,A6)=1 BTW - My spreadsheet goes up to row 3000!! However, this is now telling me that EVERY value I enter is a duplicate even if it isn't already there. PLEASE HELP ME!!!!! Thanks T -- tillytee1 ------------------------------------------------------------------------ tillytee1's Profile: http://www.excelforum.com/member.php...o&userid=27688 View this thread: http://www.excelforum.com/showthread...hreadid=524300 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Preventing duplicate data
It's still not working for me...does anyone know what I'm doing wrong?!!? Thanks T -- tillytee1 ------------------------------------------------------------------------ tillytee1's Profile: http://www.excelforum.com/member.php...o&userid=27688 View this thread: http://www.excelforum.com/showthread...hreadid=524300 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
DELETE DUPLICATE DATA IN A SHEET AUTOMATICALLY | Excel Discussion (Misc queries) | |||
Finding DUplicate Data set in Worksheets | Excel Worksheet Functions | |||
How do I compare data from 2 worksheets to find duplicate entries | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |