Lesson#112: Calculate the match percentage of text which matches another text.

Here I will discuss a interesting formula. With this formula we can calculate percentage of a text matching with another text.

In the above picture I have shown two cells. First cell having a long text value and the second cell having a small one. I will calculate If the second text is found in first text then how much percentage is matching.

So I will make an easy formula by using IF, COUNTIF and LEN functions.


The formula is working good. I had previously discussed a lesson about how to count cells which contain any part of the text.

Lesson#46: Count cells which contain any text or part of that text

Hi! I am Puspendu. I am the founder and author of Excelabcd. I am little creative person, blogger and Excel-maniac guy. I hope you enjoy my blog.

Tagged with: , ,

Leave a Reply

Your email address will not be published. Required fields are marked *