mercredi 25 février 2015

Compare Text between two cells and write in different cell excel

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