如何在Excel中将副本显示为1 else 0？

I have a column containing customer numbers(column A), there might be some duplicates in the column. What I wanted to do is, have column to the right of customer number(column B) and show 1 (if the customer number appears more than once) or 0 ( if it is unique).

我有一个包含客户编号的列(A列),列中可能有一些重复。我想要做的是,在客户编号右侧的列(B列)和显示1(如果客户编号出现多次)或0(如果它是唯一的)。

How do I solve this problem?

我该如何解决这个问题?

1 个解决方案

#1

Just write following formula in B1 and stretch it down:

只需在B1中编写以下公式并将其拉伸:

=IF(COUNTIF(A:A,A1)>1,1,0)