The function checks if two or more specified text strings or values are exactly equal and returns TRUE if they are. Otherwise, FALSE is returned. Case is important when using the EXACT function.
INDEX MATCH is a formula that combines two Excel functions: INDEX and MATCH. Based on the column and row number, =INDEX() returns the value of a cell in a table. =MATCH() returns the row or column position of a cell.
Use formulas to see if several cells are equivalent.
Please enter the following formula in a blank cell beside your data: EXACT(A1:D1,A1) =AND(EXACT(A1:D1,A1) =AND(EXACT(A1:D1 (A1:D1 indicates the cells that you want to compare, and A1 is the first value in your data range) view the following image:
The ordinary COUNTIF or COUNTIFS functions, unlike the other statistical functions in Excel, do not support case sensitivity. However, we can simulate case sensitive counting with the SUMPRODUCT and EXACT functions. When two strings are compared, the EXACT function returns a Boolean value indicating whether they are "exactly" the same or not.
Learner's Ratings
3.8
Overall Rating
50%
21%
6%
8%
15%
Reviews
R
Rishu Baghel
4
sir, can you provide us some table for practice?
S
shams faishal
4
please provide your excel file so it will be easy to learn fast
P
Pintu Kumar
5
improve video quality, because its excel file and the pixel is not good.
J
Juboraj Juboraj
4
Explain details & easy to understand.
M
MD Ayaz Rain
4
powerBI use a data Analysis course in hindi
O
Omkar Jitendra Shinde
4
It is great course
V
Vaibhav Magar
5
I would suggest Absolute reference in 13:30 for the calculation of percentage
Share a personalized message with your friends.