+ Reply to Thread
Results 1 to 4 of 4

Counting unique fields containing text and numeric values

  1. #1
    Registered User
    Join Date
    09-19-2012
    Location
    Manchester
    MS-Off Ver
    Excel 2010
    Posts
    2

    Counting unique fields containing text and numeric values

    Hi,

    I have used the advanced filter option in excel 2010 to display all the unique occurences of a list of names (column B) and then used the count function =COUNTIF(A$2:A$21,B2) to count the occurences of each name (column C).
    However, excel did not manage to take into account the last 3 entries in column A (mir-23). I assume this is because it is a mixture of text and numeric values. How can I include this information in the grouping and counting?

    Thanks



    excel1.png
    Last edited by danisha; 09-19-2012 at 09:01 AM.

  2. #2
    Forum Expert Kevin UK's Avatar
    Join Date
    12-07-2010
    Location
    Radstock, Somerset
    MS-Off Ver
    365
    Posts
    1,922

    Re: Counting unique fields containing text and numeric values

    Is B2:B7 your criteria. As mir23 etc are not in it.

  3. #3
    Registered User
    Join Date
    09-19-2012
    Location
    Manchester
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Counting unique fields containing text and numeric values

    Hi Kevin,

    Thanks for your reply.

    My intial problem is with the advanced filter. I selected the whole of column A as the 'list range' and selected the box 'unique records'. This new list was then copied to column B but the mir23 etc records are not included for some reason, and therefore are not counted.

  4. #4
    Registered User
    Join Date
    03-13-2013
    Location
    dhaka, bangladesh
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Counting unique fields containing text and numeric values

    If(countif($a$1:a1,a1)>1,"",a1)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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