Foncesa
03-31-2022, 01:35 PM
Hi,
I am using formula count to find repetitions is column F.
=IF(COUNTIF($F$2:$F$1000,F2)>1,COUNTIF($F$2:$F2,F2),"") using this in column 'J'.
There are repetitions and after every successful find create a blank row so the repetitions are visible clearly.
Thanks in advance.
I am using formula count to find repetitions is column F.
=IF(COUNTIF($F$2:$F$1000,F2)>1,COUNTIF($F$2:$F2,F2),"") using this in column 'J'.
There are repetitions and after every successful find create a blank row so the repetitions are visible clearly.
Thanks in advance.