From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Compare data with EXACT, FIND, and SEARCH functions

Compare data with EXACT, FIND, and SEARCH functions - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Compare data with EXACT, FIND, and SEARCH functions

“

- [Instructor] Excel has a number of different ways to compare data in different locations. On this worksheet, we've got some data in columns a and b. Now, at a glance, for example, a1, b1 look different. So does cell a2 and b2, but they're just a question of upper and lowercase, but in these different examples here, the problems we run into at different times often revolve around the letter i, the letter l, the number zero and capital o, and as we approach this, we could be using, for example, the if function. I'm gonna format it, prepare it in cell c1. I'll simply double-click. I'm gonna remove that leading space. What are we trying to do here? If these two match up, if they're identical, we wanna see the phrase match. Otherwise, no match. So when we press enter here, some of you might be surprised we have a match, but they certainly look different. The character that follows the number seven over here in cell b1 is a…

Contents