开发者

Field comparison in excel sheet

I have an excel sheet with two columns.

Eg.
----------------------
A            B      outputColumn C
----------------------
xxyy
dd/mm/yy     xxyy       Y
----------------------
NA          #N/A      Y
----------------------
xxyy          xxyy      Y
dd/mm/yy
----------------------
xxyy          #N/A     开发者_StackOverflow N
dd/mm/yy
----------------------
.
.
.

I want column outputColumn-C which checks if both entries are same or not. here "NA" should match "#N/A" and "xxyy" should match "xxyy dd/mm/yy"

How how can I do this?


=IF(ISERROR(IF(FIND(B1,A1)>0,"Y","N")),"N","Y")

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜