Excel how to compare 4 equal criteria in a table

Asked

Viewed 95 times

1

I have a table of player characteristics.

I need a formula that checks [TRUTH/FALSE] if all characteristics were repeated

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

NOTE: I will use only as conditional formatting I have the formula that works for 2 criteria as demonstrated below: =E($S4<>"";$T4<>"";SOMARPRODUTO(--($S4&$T4=$S$4:$S$154&$T$4:$T$154))>1)

inserir a descrição da imagem aqui

  • 2

    SE(E( NO RESOLVE? , WHICH PROJECT IS THIS? :)

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.