excel-formula - Excel: find values in column A but not in column B, return values in column C

Question

Find all values which are in column A but not in column B.

This formula searches across the entire column B for the value in cell A2. If no match is found, the formula returns "No match in B", an empty string otherwise:

=IF(COUNTIF($B:$B, $A2)=0, "No match in B", "")

• Instead of No Match in B I want the actual value in Column A to be listed. Can the formula be edited to accomplish this?

标签： excel-formula

Answer 1

在C2中的公式中替换：

“在 B 中没有匹配”

和：

2 澳元

并向下复制。