Question : check if values in two columns are equal excel
Answered by : shiny-stag-hjhvhcmelb51
=IF(COUNTIF($B:$B, $A2)=0, "No match in B", "")
Source : https://www.ablebits.com/office-addins-blog/2015/08/26/excel-compare-two-columns-matches-differences/ | Last Update : Wed, 27 Jan 21
Question : excel compare two rows
Answered by : daniel-ferry
MsgBox [and(1:1=2:2)]
Source : https://stackoverflow.com/a/29960817/3566998 | Last Update : Wed, 01 Apr 20