I have an Excel sheet as follows:
A B C D A1 B1 C1
1 Edd Eddie Edd Edd
2 Tom Hill Hill Tom
3 Gilly Trom Hill Hill
4 Abd Chikku Apple Chikku
5 Rear Back Back Back
I want to compare D1 with A, B, C and write the results as 10
in A1, B1, C1 respectively.
I tried =IF(NOT(E20=H20),"OK","NOT")
but it didn't work.
Expected Result Table
A B C D A1 B1 C1
1 Edd Eddie Edd Edd 10 0 10
2 Tom Hill Hill Tom 10 0 0
3 Gilly Trom Hill Hill 0 0 10
4 Abd Chikku Apple Chikku 0 10 0
5 Rear Back Back Back 0 10 10
Aucun commentaire:
Enregistrer un commentaire