Formula to find out difference between two columns in MS Excel.
=IF(COUNTIF($B:$B,A1)=0,"No Match in B", " ")
It will identify value which is available in column A but not in column B.
=IF(COUNTIF($B:$B,A1)=0,"No Match in B", " ")
It will identify value which is available in column A but not in column B.
No comments:
Post a Comment