Home Sign Up Sign In
mathcoder23
V2EX  ›  问与答

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

  •   
  •   mathcoder23 · Aug 16, 2016 · 4293 views
    This topic created in 3669 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   ·   3260 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 41ms · UTC 12:02 · PVG 20:02 · LAX 05:02 · JFK 08:02
    ♥ Do have faith in what you're doing.