I have a column which I have validated using the Data, Validation method.
I have used :
and dragged it down the entire column.Please Login or Register to view this content.
I need this code to be disregarded if the user enters a '-' at the end of the value in the cell...i.e. if the user enters 150 the code will still work and if there is a duplicate then the error message will appear. But if the user enters 150- then even if there is a duplicate the message will not apear.
I am completley stuck on this one... please help
Bookmarks