Sunday, 4 August 2019

find subtraction of two columns in excel

=IF(ISERROR(MATCH(B1,$A$1:$A$17,0)),B1,"")

Column A contains some strings and column B also contains some strings.
Column C will list only those strings of B which are not in A

No comments:

Post a Comment

what is a good PhD contribution?

When PhD candidates embark on their thesis journey, the first thing they will likely learn is that their research must be a “significant ori...