Ignoring everthing after a hypen
In a sumproduct formula I have a criteria that is separated by a "-".
Example:
20001-345
20001-456
20001-500
I want to include all numbers that start with 20001 in the criteria
regardless of anything that follows it. Do I convert it to text and
surround 20001 in " "s?
Thanks for any and all help!!
Steve
|