This problem can be solved with the RIGHT function, as explained below.
RIGHT function
TheRIGHT functionextracts a given number of characters from therightside of a text string.
However, this value needs to be modified to suit the situation.
EXACT will only return TRUE whentext1andtext2are exactly the same, taking into account case.
The second formula returns TRUE because “JWB"doesequal “JWB” taking into account case.
This means you might’t use COUNTIF to test values in an array returned by another operation.
For example, =RIGHT(“apple”,3) returns “ple”.
