EXCEL 选出重复数据

=COUNTIF(A:A,A1)

【Excel如何提取重复项数据】https://www.bilibili.com/video/BV12741187if?vd_source=90a165c1cb31e4b446ecb538c3e47959