Hi
I am using following formula for duplicated numbers from range A3 to A15000(=Countif($A$3:$A$15000,A3)>1)
I want with this conditional format that when any number is duplicated it gives me a message the following number is duplicated and take me above of first duplicated number.
Thanks in advance
I am using following formula for duplicated numbers from range A3 to A15000(=Countif($A$3:$A$15000,A3)>1)
I want with this conditional format that when any number is duplicated it gives me a message the following number is duplicated and take me above of first duplicated number.
Thanks in advance