+ Reply to Thread
Results 1 to 5 of 5

count number in column

  1. #1
    Forum Contributor
    Join Date
    11-17-2015
    Location
    India
    MS-Off Ver
    2013
    Posts
    365

    count number in column

    I have number in column C


    as below

    C=1 1
    C=2 1
    C=3 1
    C=4 1
    C=5 2
    C=6 2
    C=7 2
    C=8 2
    C=9 3500
    C=10 3500
    C=11 3500
    C=12 3500
    C=13 3500
    C=14 4
    C=15 4
    C=16 4
    C=17 4
    C=18 4
    C=19 4
    C=20 878787
    C=21 878787
    C=22 878787
    C=23 878787
    C=24 878787
    C=25 11
    C=26 11
    C=27 11
    C=28 11
    C=29 11


    in column E I wants to count number same number in column and give serial number for same number. please refer attachment. I have given the desired output in column E
    Attached Files Attached Files

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: count number in column

    Try this one
    in E2 and copy down

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  3. #3
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,732

    Re: count number in column

    in E2 put
    =IF(C2=C1,E1+1,1)

    this will count the sequence
    so
    1
    1
    1
    2
    2
    2
    1
    1
    1

    the 2nd group of 1's will start at 1 again
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  4. #4
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: count number in column

    Hello saravanan1981,

    Since you also posted this request in the VBA Macro forum, you are probably looking for a VBA solution.

    I have added the macro below to the attached workbook. There is a button on the worksheet to run the macro.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  5. #5
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: count number in column

    Or

    Please Login or Register  to view this content.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Count the number of gaps of a number occured in a column
    By eiistrir in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 02-21-2014, 07:05 AM
  2. [SOLVED] Count the number of items sold in one column based on the quantity in another column
    By mike_m1 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-20-2013, 05:48 AM
  3. [SOLVED] Count the number of unigue numbers based on number in another column.
    By ksmith4809 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-27-2013, 09:11 AM
  4. [SOLVED] count the number of times each string appears in a column and make a summary column
    By intothewild in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-04-2012, 08:02 AM
  5. [SOLVED] Filtering macro, count number of rows and include count in last column.
    By Folshot in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-12-2012, 07:17 AM
  6. Replies: 9
    Last Post: 06-08-2012, 06:22 PM
  7. Count row number and populate column with count number
    By ajay1967 in forum Excel General
    Replies: 3
    Last Post: 12-01-2011, 02:49 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1