Search Not Just Numbers

Loading...

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".

2 comments:

  1. In the event you ever discover a card skimmer fendi outlet, don't just flee the ATM for safer pastures. There's no telling how many people could fall victim to a skimming scheme until the foreign devices are discovered by someone prada handbags else. If the ATM is at a bank, informing a bank employee is the easiest solution. Even if the bank isn't familiar with card skimmers, they can still shut the ATM down. If you're not at a bank, check the face of the ATM and its display screen http://www.cityofwestwego.com/home.asp for a contact number. By protecting your PIN and staying observant every time you use an ATM -- keeping an eye out for hidden cameras replica handbags, fake panels and card readers -- you'll hopefully keep your money safe, and out of the hands of thieves who steal more than $1 billion annually through credit card and lv outlet ATM fraud [source: Siciliano].

    ReplyDelete
  2. Low-cost clutches incorporates a risk as well as the frequently it really is intertwined together with artificial clutches. replica dior bags The essential reality that you would like to get low-cost will not actually entail what you can do will probably be restricted to artificial kinds. chanel replica sale Not really, you can find designer's hand bags on the market you could nonetheless get some good discounts and also special discounts. How will you guaranteeing that everything you are usually getting will be traditional? gucci replica sale Inserting the buy on the web will not deceive the proper regarding inspecting in the event the thing to get will be genuine or perhaps artificial. It is possible to openly require initial yet absolutely, they are going to point out sure, it really is genuine. cartier replica sale Today, it is possible to require virtually any ensure in the event the merchandise acquired regarded artificial, just like get the money-back sort carry out products. chanel replica Buying a low-cost designer purse inside the net is not that tough once you learn where you should move. gucci replica The net gives an individual plenty of choice to go shopping, nonetheless, no person can easily supply just what she or he is declaring are usually correct.

    ReplyDelete