excel 如何统计一列数据中的每个数据的重复次数

V2EX = way to explore

V2EX 是一个关于分享和探索的地方

For Existing Member Sign In

This topic created in 3542 days ago, the information mentioned may be changed or developed.

比如: A 1 1 2 3 3

绘制一个柱状图: 1,2,3 分别出现的次数

3 replies • 2016-08-16 10:12:48 +08:00

ethanlu

Aug 16, 2016

countif

F281M6Dh8DXpD1g2

Aug 16, 2016 via iPhone

数据透视表

RockShake

Aug 16, 2016

透视表，把 count 拖出来