Forum Discussion
Alexander Fries
Jul 14, 2018Copper Contributor
Comparing the data of 2 columns
Hi, I'm trying to compare the data of two sets of 6 columns each (i.e. comparing column 1 of set 1 with column 1 of set 2 etc.). Both columns have one of three answers options in each cell. Howev...
- Jul 14, 2018
So you can just use an IF condition:
IF(H1="same";"";if(H1=H2;"same";"different"))