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!!! |
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 |