I have some problem with this excel formula =IF(A2:J2=O2,"Yes","No")
I am testing this if condition to whether O2 cell is matching with an element in A2:J2. But the formula is displaying in the other 10 cells.
How can I get rid of this issue and execute the formula in only one cell?
Aucun commentaire:
Enregistrer un commentaire