Search Not Just Numbers

Tuesday, 8 April 2014

Excel Tip: When case matters...

Just a very short tip for this week.

Do you ever have a situation where you need to compare two values but you don't want to treat them as the same if one is upper case and the other is lower case?

As far as Excel is concerned, "A"="a"!

Fortunately, there is a function in Excel that can help.

The EXACT function allows you to compare two values and returns TRUE if they are EXACTLY the same, including case.

So,

where

=IF("A"="a","The same","Different")

returns "The same"

=IF(EXACT("A","a"),"The same","Different")

returns "Different"

That's it! Simple, but handy if you need it.
Excel Expert Course

If you enjoyed this post, go to the top of the blog, where you can subscribe for regular updates and get two freebies "The 5 Excel features that you NEED to know" and "30 Chants for Better Charts".

No comments:

Post a comment