Hello and welcome to our new video
In this video we are going to learn
About exact formula
How does exact formula works
Suppose you have two cells
In first cell I wrote my name Rahul
I wrote in capital
In second cell I wrote same name
But what I did is
I wrote first letter in small
So exact formula will match
These two
And when it will match
The name in first cell is in capital
But in second cell
The name in first letter is in small
So this is not exact match
Other than this
Sometimes we do typing error
That I wrote Re instead of Rahul
So all such things
Exact formula tells us
If it is not exact match
Then it will return a value
If it is exact match then it will return true value
I will tell you after doing this
To do this
We have to open excel
And Here we have
Jethalal and Babita
Again Jethalal There is a space between Jethalal and Babita
Babita B is in capital
B is in small
Atmarambide Is in space
Rajkumar Is in space
Thor T is in small
So Before going to exact
Let's see what we can do
To compare these two
To compare simple
You have to type equals to
And before the name
I will increase the size
You have to compare these two
To compare
You have to type equals to
And here
Select this cell
Or you know its name
F3 Selected And again
Selected this cell
Because we have to compare
Exactly same or not
Entered Value returned
False If true
It means it is exact match
Let's see
Other values 2nd value
True 3rd value
False Here First letter is capital
Here small
Normally When we compare
It does not take case sensitive
What is case sensitive
Case sensitive
Because Name is same
But here
This is capital
This is small
Normally When we use this formula
It ignores the case
It does not count
It does not see
Babita is in this cell
Babita is in other cell
It does not matter
It is capital
But exact formula
It means 3rd value
False Here is space 4th value
Here is space
Here is not space 5th value
True First letter is capital
Here small
It ignores
Because we are using equals to
We are not using exact formula
I hope you understood
Now Let's use exact formula
For formula
Equals to sign
After equals to sign
We have to write exact
Let's write
Equals to
Then we write exact
Double click
It is asking
Text 1 and text 2
Then I put comma
Then text 2
After that
I closed bracket
Then false
Why false
It should be false
Because here is space
Let's see other values
Drag it down
Here In this case
True False It considers
Exact formula
Normal formula
It does not consider
Here all values are false
Here also false
Because here capital
Here not
Here also false
But T is small
Here capital
Let's change
Here Capital Enter Here value changed
True What else
Here Let's see
Space True Enter This value is true
We compared
Space Here Here Normal It does not consider
Small letters
Here also false
How to make it true
Go to
Capital Enter It is true
I hope you understood
How to use exact formula
Now Where does it help
Sometimes When you are writing data
Sometimes Error Error Error Error Error Error Error Error
Error Error Error Error Error Error Error Error Error Error
Error Error Error Error Error Error Error Error I hope it
will be clear to you, if you still have any doubt, then
play this video again, I will meet you in the next video,
till then keep practicing.