Im working on a project for the boss and need help with data like the following:
001.002.001.003
001.004
001.004.001
001.004.002
001.004.005
001.004.007
001.004.007.002
001.004.007.003
001.004.009
001.005
001.005.001
001.005.002
001.007
001.007.001
001.007.002
001.008
001.008.002
001.008.003
001.008.005
001.008.005.001
001.008.006
001.008.006.002
It obviously accending but I cant get it to work with formulas or convert into a format that it can work with. I need to be able to asign a value based on one of these numbers...assuming these numbers are in column "A" in want to do something like the following =IF(A1>001.008,YES, NO)
There are about about 1200-1500 series of numbers per sheet and I have several hundred sheets so deleting periods or changing the numbers would not be feasable...
ANY HELP APPRECIATED!!!
THANKS!
Bookmarks