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.
Explain details & easy to understand.
MD Ayaz Rain
powerBI use a data Analysis course in hindi
Omkar Jitendra Shinde
It is great course
I would suggest Absolute reference in 13:30 for the calculation of percentage
Hafiz Muhammad Talha
kindly share your slides for revision
Sohel Khalid Nadaf
How to get dataset
I am looking for this course in Telugu language, Is there any possibilities in Telugu.