Unique Value Returns with Exact Match

[nhartman49]

I am looking for a way to extract unique exact values from a text string. I have found way to get multiple values but they are not exact.

Examples:

A1- Unique Values:
19
20
35
40

B1 - There were 40 cats who ran up a tree in 1920.

C1 - Result:
19
20
40

I would need the result to be 40 only because it is the only exact match to the criteria.

Thank you.

 

[nhartman49]

For some reason and I honestly don't know why it worked perfectly this time!!!! Thank you two for your outstanding help!!!!! I may have been the issue and not the formulas. Thank you all again!!!!!!

 

[jtakw]

You're welcome.