Validate cells with the same value with a formula in an excel report
This formula will check if all the 3 cells have the same value, quite useful to validate it but much more useful, combine with the IF function for instance so I can ask it to change one of the values or something else.
When I use the formula ?
To check that all cells have the same result.
How to use the formula ?
The formula in this topic is with "," so depending of the operating system of your PC, the formula should have ";" instead of ",".
For the formula to work properly, I need to do an additional action, by pressing “control + shift + enter” in order to put the formula between brackets. If not, it will show an error
How is/are the formula(s) ?
=AND()
=EXACT()
Put this formula:
{=AND(EXACT(A2:C2,A2))}
Then press CTRL + ALT + ENTER to put it into bracket.
Interesting Topics
-
Be successfully certified ITIL 4 Managing Professional
Study, study and study, I couldn’t be successfully certified without studying it, if you are interested...
-
Be successfully certified ITIL 4 Strategic Leader
With my ITIL 4 Managing Professional certification (ITIL MP) in the pocket, it was time to go for the...
-
Hide visual and change background color based on selection
Some small tricks to customize the background colour of a text box...
-
Stacked and clustered column chart or double stacked column chart
In excel, I use a lot the combination of clustered and stacked chart...