+ Reply to Thread
Results 1 to 4 of 4

Frequent number for every category

  1. 04-27-2015, 05:31 AM #1
    Ankit_Kumar
    Ankit_Kumar is offline
    Registered User
    Join Date
    04-20-2015
    Location
    India
    MS-Off Ver
    2013
    Posts
    77

    Frequent number for every category

    Hello Everyone,

    I have data in range A1:B13. Column A contains category and column B contains number. I want to find the number that occurs most frequently for each category.

    For reference I attached the Excel file.

    I want if I select any category in cell D2 most frequent number should be occur.

    Thanks
    Ankit
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-27-2015, 05:33 AM #2
    Nisha Dhawan
    Nisha Dhawan is offline
    Valued Forum Contributor
    Join Date
    05-07-2014
    Location
    India
    MS-Off Ver
    MS Office 365
    Posts
    313

    Re: Frequent number for every category

    Hi Ankit,

    Please use this function in cell E2 :- =MODE(IF($A$2:$A$13=D2,$B$2:$B$13))

    Press the key Ctrl+Shift+Enter
    Thanks
    Nisha Dhawan


    If you like my answer please click on * Add Reputation
    "If you can dream it, You can do it "
    Reply With QuoteRegister To Reply
  3. 04-27-2015, 06:07 AM #3
    Ankit_Kumar
    Ankit_Kumar is offline
    Registered User
    Join Date
    04-20-2015
    Location
    India
    MS-Off Ver
    2013
    Posts
    77

    Re: Frequent number for every category

    Thanks Nisha it works
    Reply With QuoteRegister To Reply
  4. 04-27-2015, 06:15 AM #4
    Nisha Dhawan
    Nisha Dhawan is offline
    Valued Forum Contributor
    Join Date
    05-07-2014
    Location
    India
    MS-Off Ver
    MS Office 365
    Posts
    313

    Re: Frequent number for every category

    Hey Anki - Mark this thread as SOLVED if your query has been resolved.

    Thanks
    Nisha
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Extracting most frequent number(s)?
    By figeroa in forum Excel General
    Replies: 4
    Last Post: 09-08-2014, 06:29 AM
  2. Check most frequent number in 1 column that has 4 digits number
    By Merson78 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 06-07-2014, 10:57 PM
  3. Personal budget - add a number to a main category if i manualy add a number in a category
    By andreasnw in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-24-2014, 12:37 PM
  4. Find the most frequent and second most frequent text string whilst ignoring numbers
    By Puni in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 03-20-2012, 09:53 PM
  5. Retrieving the Most Frequent Occurrence for Each Category
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 08-25-2005, 02:24 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1