+ Reply to Thread
Results 1 to 3 of 3

count and category comma separated numbers.

  1. #1
    Registered User
    Join Date
    10-01-2018
    Location
    Ragama
    MS-Off Ver
    Office 2007
    Posts
    2

    count and category comma separated numbers.

    I have this kind of comma separated numbers in "Original file", column A (in cells - A1, A2, A3)

    4,5,7,8,9,16,17,18,19,20,21,22
    4,5,6,7,8,9,16,17,18,19,20,22,23,24
    4,5,6,7,8,9,16,17,18,19,20,21


    I need to calculate how many unique numbers in those cells,
    such as...

    1-0
    2-0
    3-0
    4-3
    5-3
    6-2
    .
    .
    .
    .
    21-2
    22-2
    23-1
    24-1 and so on.

    I find it with the value which locate in cell B1.

    I try this formula - {=COUNT(FIND(B1,'Original File'!$A$1:$A$3))}

    but it counts all 1s and 2s which is in 12,21,22 and all other numbers also.

    please help me.. thanks

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,941

    Re: count and category comma separated numbers.

    Try below formula
    Please Login or Register  to view this content.
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Registered User
    Join Date
    10-01-2018
    Location
    Ragama
    MS-Off Ver
    Office 2007
    Posts
    2

    Re: count and category comma separated numbers.

    Thanks mate.. it works.. excellent..

+ 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. Count words separated with comma?
    By ciapul12 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-30-2018, 05:21 AM
  2. [SOLVED] Comma separated string element count
    By icyrius in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-30-2017, 10:58 AM
  3. How to count values separated by a comma
    By peterderrington in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-24-2017, 11:50 AM
  4. [SOLVED] How to count values separated by a comma
    By PlamSa in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 11-19-2013, 09:10 AM
  5. count of comma separated values
    By bujji1305 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-01-2012, 07:33 PM
  6. count comma separated information
    By fjosef87 in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 04-04-2010, 10:47 AM
  7. [SOLVED] Count comma separated numbers, numbers in a range with dash, not t
    By Mahendra in forum Excel General
    Replies: 0
    Last Post: 08-08-2005, 01:05 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