Find duplicate with a formula in an excel report

This formula allows me to find either a duplicate or an unique value.

macro excel


When I use the formula ?

To find duplicate values.


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