+ Reply to Thread
Results 1 to 3 of 3

Returning the Highest Count of a row of Values

  1. #1
    Forum Contributor
    Join Date
    06-25-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2016
    Posts
    615

    Returning the Highest Count of a row of Values

    Hi all,

    Have attached a sample sheet where rows A to L have a value. I want to be able to return the value in the row that has the most matched entries. In the sample it would be number 4 with 3 counts as shown in M and L.

    In the (likely) event of 2 or more numbers returning the same count I want to return a NIL result for that row.

    Hope that makes sense.

    Cheers
    Hammer
    Attached Files Attached Files
    Last edited by hammer2; 12-06-2011 at 09:25 PM. Reason: Solved

  2. #2
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: Returning the Highest Count of a row of Values

    M2,

    =if(count(mode.mult(a2:l2))=1,mode(a2:l2),"nil")

    l2,

    =if(m2="nil","",countif(a2:l2,m2))
    Last edited by Haseeb Avarakkan; 12-06-2011 at 08:57 PM. Reason: Forgot about the 2nd condition.
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

  3. #3
    Forum Contributor
    Join Date
    06-25-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2016
    Posts
    615

    Re: Returning the Highest Count of a row of Values

    Billiant!! Thank you so much.

+ 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