Home Sign Up Sign In
mathcoder23
V2EX  ›  问与答

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

  •   
  •   mathcoder23 · Aug 16, 2016 · 4460 views
    This topic created in 3730 days ago, the information mentioned may be changed or developed.

    比如: A 1 1 2 3 3

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

  • 柱状图
  • 次数
  • EXCEL
  • 绘制
    3 replies  •  2016-08-16 10:12:48 +08:00
    ethanlu
        1
    ethanlu  
       Aug 16, 2016
    countif
    F281M6Dh8DXpD1g2
        2
    F281M6Dh8DXpD1g2  
       Aug 16, 2016 via iPhone
    数据透视表
    Crixs
        3
    Crixs  
       Aug 16, 2016
    透视表，把 count 拖出来
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   2800 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 38ms · UTC 14:05 · PVG 22:05 · LAX 06:05 · JFK 09:05
    ♥ Do have faith in what you're doing.