Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

Comparing the strings in excel.

  • 23 July 2013
  • Author: Anil
  • Number of views: 8805
  • 0 Comments

While working I need to compare between the two column string words in excel file and like other integer column compare  we cannot simply use column1 – column2 (=A1-B1) , so while Google I found simple solution by using anEXACT function as =EXACT(A1,B1) command. Which returns TRUE or FALSE values after comparing and will return true if the strings are identical.  COOL :) ..!!!

Simple e.g.:  comparing the current changed state name based on same zip code:

  A1                                                                B1                                                      C1                     

Arizona

 

 

ABC

FALSE

Arkansas

 

 

Arkansas

TRUE

California

 

 

California

TRUE

Colorado

 

 

Colorado

TRUE

New Mexico

 

 

NewCity

FALSE

New York

 

 

New York

TRUE

North Carolina

 

 

North Carolina

TRUE

It’s just and simple task but may help to others who need as above solution. 

Thanks,

Anil Maharjan

Print
Categories: Analysis Services
Tags:
Rate this article:
No rating
Anil

AnilAnil

Highly motivated Business Intelligence Engineer having leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision. Has more than 5 years of development & implementation experience in HealthCare Data Analytics and Telecommunication

Other posts by Anil

Full biography Contact author

Please login or register to post comments.