Duplicate formula not working

[cc9083]

Hi there.
I have 10 columns consisting the formula below both vertically and horizontally. I have another column at the end to identify duplicates horizontally for column 1 to 10.

Formula for column 1 to 10
{=IF(COLUMNS($F11:F$12)<=$E11,INDEX($A$11:$A$1001,SMALL(IF($B$11:$B$1001=$D11, ROW($B$11:$B$1001)-ROW($B$11)+1),COLUMNS($F11:F$11))),"")}

Formula for duplicate
=IF(COUNTIF($F11:O11,O11)>1,"Duplicate","")

My issue is the duplicate formula is not working unless the data in column 1 to 10 are figures and not the above formula. Can anyone assist. Thanks in advance.

 

[Ivan F Moala]

perhaps ??

{=IF(COUNTA(Rng)-SUM(COUNTIF(Rng,Rng)/IF(NOT(COUNTIF(Rng,Rng)),1,COUNTIF(Rng,Rng))^2)>0,"Duplicates","")}

where Rng = $F11:O11

 

[cc9083]

Hi Ivan. Where shall I use this formula? I place it in column no. 11 but it came out as text rather than formula

 

[cc9083]

The formula for column 1 to 10 is correct. I only need a formula that recognises the output of the formula that will be used as input for the duplicate formula. Hope everybody understands my point.

 

[cc9083]

Can anyone assist me on this. Thanks.