Excel how to compare 4 equal criteria in a table

1

I have a player characteristics table.

I need a formula that checks [TRUE / FALSE] if all of the characteristics were repeated

The table is contained in the following range: $ R $ 3: $ X $ 2004 The criteria range is: $ S $ 3: $ V $ 2004

NOTE: I will only use as conditional formatting I have the formula that works for 2 criteria as shown below: ($ S4 & $ T4 = $ S $ 4: $ S $ 154 & $ T $ 4: $ T $ 154)) > 1)

    
asked by anonymous 24.12.2018 / 15:25

0 answers