+ Reply to Thread
Results 1 to 2 of 2

Number of times each number appears in a column

  1. 10-02-2016, 06:27 PM #1
    AL9787
    AL9787 is offline
    Registered User
    Join Date
    10-02-2016
    Location
    USA
    MS-Off Ver
    8
    Posts
    1

    Number of times each number appears in a column

    Good afternoon
    I have a column of numbers
    I want to count the number of times each number appears in the column
    I don't want to have to specify the numbers because there are many numbers
    which function should I use to count the number of times each number appears in the column? Thank you
    Reply With QuoteRegister To Reply
  2. 10-02-2016, 06:38 PM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,707

    Re: Number of times each number appears in a column

    Use a pivot table
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Add the number of times text appears in column
    By paladin7 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-09-2014, 06:11 AM
  2. Identify in a column when the same number appears more than 10 times in a row
    By bing77025 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-22-2012, 10:26 PM
  3. [SOLVED] Count number of times of name appears in a column
    By Ness78 in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 08-01-2012, 08:14 AM
  4. [SOLVED] find number of times a letter or a number appears in a column
    By dcoates in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-17-2012, 02:47 PM
  5. Excel 2007 : Counting number of times x appears in a column
    By benoj2005 in forum Excel General
    Replies: 2
    Last Post: 03-14-2012, 08:12 AM
  6. How to count the number of times a date appears in a column
    By smellsgood in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-31-2010, 06:35 AM
  7. Need to Organize by Number of Times Value appears in a Column
    By Draken50 in forum Excel General
    Replies: 1
    Last Post: 03-11-2009, 03:40 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1