+ Reply to Thread
Results 1 to 6 of 6

List - Count Item repeated maximum number of times

  1. #1
    Valued Forum Contributor saravnepali's Avatar
    Join Date
    01-14-2019
    Location
    Sydney Australia
    MS-Off Ver
    2010
    Posts
    447

    List - Count Item repeated maximum number of times

    Hi,

    I have a excel sheet where I have several parts names repeated.

    Say in total there are 12 different parts names repeated over 250 rows.

    But is there a way to find out which is repeated the maximum number of times.

    I tried to use COUNTIF function and loop to search for each in the range.

    Is there a better way?
    Attached Files Attached Files
    If you think someone helped you, click on the "* Add Reputation" as a way to say thank you.

    If your problem is solved, go to Thread Tools and select Mark This Thread Solved

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: List - Count Item repeated maximum number of times

    A pivot table?

    Rows >> Name3
    Values >> Count of Name3

    https://www.pivot-table.com/
    HTH
    Regards, Jeff

  3. #3
    Valued Forum Contributor saravnepali's Avatar
    Join Date
    01-14-2019
    Location
    Sydney Australia
    MS-Off Ver
    2010
    Posts
    447

    Re: List - Count Item repeated maximum number of times

    Yes a pivot table will do the job

    But I want to avoid to create a pivot table, if possible through other options.

    Something like nested countif functions, not sure that will give me the total count
    Last edited by saravnepali; 11-25-2019 at 07:31 PM.

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: List - Count Item repeated maximum number of times

    In your spreadsheet you state...

    I am after easiest way to figure that out
    IMHO, a pivot table is the easies method.

    If you want a different approach, check out this thread.

  5. #5
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: List - Count Item repeated maximum number of times

    Does this help ?

    Please Login or Register  to view this content.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  6. #6
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: List - Count Item repeated maximum number of times

    Quote Originally Posted by saravnepali View Post
    Something like nested countif functions, not sure that will give me the total count
    Please Login or Register  to view this content.

+ 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 number of times an item appears in the list
    By arthur_b in forum Excel General
    Replies: 4
    Last Post: 05-04-2019, 06:57 AM
  2. Replies: 4
    Last Post: 07-31-2018, 04:24 PM
  3. [SOLVED] Count maximum times same number used in a row by criteria
    By mrsak87 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-11-2018, 02:32 PM
  4. Replies: 4
    Last Post: 04-17-2012, 03:24 PM
  5. Count Max Times a Number Continiously Repeated
    By Azam Ali in forum Excel General
    Replies: 4
    Last Post: 10-13-2011, 07:33 AM
  6. Find out aplhanumeric value repeated maximum times in an excel
    By parulg in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-28-2010, 05:21 AM
  7. Replies: 3
    Last Post: 07-14-2005, 08:53 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1