i have a excelsheet 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
What i want is to compare D1 with A , B, C and write the result as "10" in the A1 , B1 ,C1 respectively ,
I have tried =IF(NOT(E20=H20),"OK","NOT") but didnt worked
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