Hi,
"An example estimate number is 13-1492 - 13 meaning the year and the number is generated by drilling down B3+1."
Can you expound upon this part, please? If I have "13-1492" in cell B3, then =B3+1 will return a #VALUE! error since I am attempting to perform addition with a text value.
Regards
Bookmarks