Sumproduct Formula

[cyliyu]

Can sumproduct use to check TEXT if both cell L6 and N6 are text?

=IF(L6="","",IF(N66="","",IF(SUMPRODUCT((L$6:$L6=L6)*(N$6:$N6=N6))>1,"Repeased","")))

 

[NARAYANK991]

Hi ,

Please explain , in plain English , what you wish to do.

Narayan

 

[cyliyu]

The command helps to identify if both the cell numbers (serial no and date code) match, if yes, it shows and display "Repeated".



And I wanted to apply the same formula to Text, e.g. Car 1 and Engine 1. any suggestion?

 

[NARAYANK991]

Hi ,

Instead of posting a screenshot , it would have helped if you had uploaded your workbook.

Try this :

=IF(L6="","",IF(N6="","",IF(SUMPRODUCT((L$6:$L$66=L6)*(N$6:$N$66=N6))>1,"Repeated","")))

where I have used 66 for the last row of data.

Narayan

 

[cyliyu]

Noted.
Thanks Narayan. The formula works for me.