Thanks Killer17.
Can anyone help with the following:
What was incorrect about the formula I first had? Should the wildcard (? or *) only be used for text or something?
=IF(A1="?????01","YES","NO")
Also - if I want to search for projects that have the first decimal point being 1-9 is there an easy way I can do this? eg. 1002.10, 1002.20 to 1002.90
Thanks again.
Bookmarks