Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cannot extend the range of data I'm trying to prevent duplicates i
I used this website to help me set up the validation to stop duplicates,
which worked perfectly until I got to the cap of 2000. http://www.ozgrid.com/Excel/prevent-duplicates.htm Now I cannot change the range to go any higher than 2000 no matter what I try. I have used the same directions I did before and it gives me errors and does not work when i enter data past 2000. Help!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cannot extend the range of data I'm trying to prevent duplicates i
I don't know where your cap of 2000 comes from. Is that the highest row
number you entered into your data validation formula? I just tested the same validation down to row 10000 and it worked fine in Excel 2003. You could try this: - select the whole column where the validation is applied - select Data Validation Clear All - in the Allow dropdown box, select Custom - enter this formula (changing the column references as needed): =COUNTIF($A$1:A$10000,A1)=1 - click OK Hope this helps, Hutch "wintergems" wrote: I used this website to help me set up the validation to stop duplicates, which worked perfectly until I got to the cap of 2000. http://www.ozgrid.com/Excel/prevent-duplicates.htm Now I cannot change the range to go any higher than 2000 no matter what I try. I have used the same directions I did before and it gives me errors and does not work when i enter data past 2000. Help!!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cannot extend the range of data I'm trying to prevent duplicates i
First of all, I would not trust anything that came from a site where the author
uses the term "absolution" with respect to changing cell references from relative to absolute. What forgiveness has to with cell references is beyond me. Second of all, why can't you edit the formula to =COUNTIF($A$1:$A$12345,A1)=1 then use the format paintbrush to copy down or just select A1:A12345 before entering the formula? Gord Dibben MS Excel MVP On Wed, 19 Mar 2008 08:14:01 -0700, wintergems wrote: I used this website to help me set up the validation to stop duplicates, which worked perfectly until I got to the cap of 2000. http://www.ozgrid.com/Excel/prevent-duplicates.htm Now I cannot change the range to go any higher than 2000 no matter what I try. I have used the same directions I did before and it gives me errors and does not work when i enter data past 2000. Help!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unchecking "Extend data range formats" is not workingfor row shading | Excel Discussion (Misc queries) | |||
Painting Range - extend the range on the top part | Excel Discussion (Misc queries) | |||
Extend a data range | New Users to Excel | |||
Extend data range format and formulas | Excel Worksheet Functions | |||
extend data range formats and formulas | Setting up and Configuration of Excel |