Array formula to search table with matching fields

[datamster]

Hello,

I have a table and I'm trying to make another column with an array formula that shows if fields in that row match other criteria found elsewhere in the specified columns. Here is the formula I'm attempting to use, {=IF(AND(C11=[call_sign],F11=[registration],I11=[origin]),TRUE,FALSE)}. In the array everything shows as FALSE and without the array everything shows as TRUE. Please let me know if my description needs clarification. Thank you for any help.

 

[steve the fish]

You cant use AND in an array formula. What is it you are trying to do?

 

[datamster]

You cant use AND in an array formula. What is it you are trying to do?

Hi Steve, thanks for the reply. I'm trying to determine if each row in the table is a duplicate based on columns C, F and I. I'd like the result to show either true or false for filtering in a pivot table. This is all part of an automated report so any manual intervention should be avoided. Below is a sample of the data.

B C D E F G H I 12/10/2016 16:26 ARL1410 ARL Airline N923AN Inbound B738 LGA 12/10/2016 16:29 ARL994 ARL Airline N838NN Inbound B738 MGA 12/10/2016 16:30 ARL994 ARL Airline N838NN Inbound B738 MGA 12/10/2016 16:30 ARL994 ARL Airline N838NN Inbound B738 MGA 12/10/2016 16:35 ARL1498 ARL Airline N865NN Inbound B738 MEX 12/10/2016 16:40 ARL1350 ARL Airline N951AA Inbound B738 STT 12/10/2016 16:41 ARL373 ARL Airline N996NN Inbound B738 EWR 12/10/2016 16:41 ARL994 ARL Airline N838NN Inbound B738 MGA 12/10/2016 16:43 ARL1274 ARL Airline N910AN Inbound B738 BOS 12/10/2016 16:46 ARL2282 ARL Airline N136AN Inbound A321 POS 12/10/2016 16:57 ARL2449 ARL Airline N12028 Inbound A319 FLL <tbody> </tbody>

<tbody>
</tbody>

 

[steve the fish]

Try:

=IF(COUNTIFS($C$2:C2,C2,$F$2:F2,F2,$I$2:I2,I2)>1,"Duplicate","OK")

 

[datamster]

Try:

=IF(COUNTIFS($C$2:C2,C2,$F$2:F2,F2,$I$2:I2,I2)>1,"Duplicate","OK")

Perfect! I had to add offset to keep from counting itself so. Thanks for the help. Here's the formula I used,
=IF(COUNTIFS(OFFSET(C11:C269,1,),C11,OFFSET(F11:F269,1,),F11,OFFSET(I11:I269,1,),I11),"Duplicate","OK")