+ Reply to Thread
Results 1 to 6 of 6

Count the number of unigue numbers based on number in another column.

  1. #1
    Registered User
    Join Date
    03-26-2013
    Location
    Louisiana
    MS-Off Ver
    Excel 2010
    Posts
    3

    Count the number of unigue numbers based on number in another column.

    I need to count the number of unique numbers in column C and display the number of unique numbers that occur in column C for each unit number in column F.
    Match the number of unique numbers to each unit number in column L to build data table. A pivot table will not work for the overall project.

    Thanks to all.


    Excel QuestionII.xlsx

  2. #2
    Forum Expert icestationzbra's Avatar
    Join Date
    01-07-2004
    MS-Off Ver
    2007, 2010
    Posts
    1,417

    Re: Count the number of unigue numbers based on number in another column.

    see if this ARRAY formula helps in cell M2, drag-filled down:

    Please Login or Register  to view this content.
    - i.s.z -
    CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
    Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
    All good ideas are courtesy resources from this forum as well as others around the web.
    - e.o.m -

  3. #3
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Count the number of unigue numbers based on number in another column.

    Here's another one...

    Array entered** in M2 and copied down as needed:

    =SUM(IF(FREQUENCY(IF(F$2:F$720=L2,C$2:C$720),C$2:C$720),1))

    ** array formulas need to be entered using the key
    combination of CTRL,SHIFT,ENTER (not just ENTER).
    Hold down both the CTRL key and the SHIFT key
    then hit ENTER.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  4. #4
    Registered User
    Join Date
    03-26-2013
    Location
    Louisiana
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Count the number of unigue numbers based on number in another column.

    Thank you very much. I thought I had tried this formula earlier but I obviously had an error along the way.

  5. #5
    Registered User
    Join Date
    03-26-2013
    Location
    Louisiana
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Count the number of unigue numbers based on number in another column.

    Thank you.

    I can not agree more with your KISS motto. This is great.

  6. #6
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Count the number of unigue numbers based on number in another column.

    You're welcome. Thanks for the feedback!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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