What is the use of Exact Function in excel ?
Exact function helps us to match (or) compare the values in two columns/cells in excel. Before going to enter the formulas please note that exact functions are case-sensitive,means if the 1st column values are in the uppercase & the 2 ed column values in lowercase. then the formula will show false result.
So before going to start putting formula's to your values change the Case-Sensitive of your entire sheet for better result.
Click here to learn how to change Case-Sensitive in excel
Now Let we see how to use Exact Function in excel.Please follow the pictures to learn & please put a comment about picture quality.if you are not happy with the Picture animation please let me know to do something.
Go to formulas tab select text & click exact the screen with you are looking in the image Function Arguments will appear. just select the text which you want to know the result & click ok.
Above & the below picture will explain you differences between the text 1 & text 2 .
Here the formula in zoom effect. = Exact(B6,C6)
I hope this picture helped you to learn exact function.also you can see my video for exact function Right here
0 comments:
Post a Comment