mercredi 25 février 2015

Compare text between cell pairs and conditionally write to other cells

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