UNIX for Dummies Questions & Answers

Hi All,

i have a excel sheet with two columns as below.

column1 column2
100 100
200 300
300 400
400 400
500 600

i need to compare the values these two columns and the output should be printed in the third column...if these values are equal the output should be green and if these vlues are not equal output value should be red.. please see the output format below..

column1 column2 column3
100 100 green
200 300 red
300 400 red
400 400 green
500 600 red

please help me in writing a unix code for the above requirement...

Thanks in advance.
Arun Manas

Try if this awk fills your requirement (can be shorter probably )

Code:

awk '{if ($1==$2) print $0 FS "green"; else print $0 FS "red" } ' inputfile

put your column1 values to A column in excel file
put your column2 values to B column in excel file

place the below formula in C1 and enter. After that drag the formula to end of your values in A and B column

Code:

 
=IF(COUNTIF(B:B,A1),"Green","Red")