It is rare that I use this formula but at least, I used it one time. It allows to find in which row is located the value I am looking for.
When I use the formula ?
When I need to know the row number of a specific value.
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 ",".
How are the formulas ?
Put this formula: