Find the row ID with a formula in an excel report

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.

formula excel


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:


Interesting Management