+ Reply to Thread
Results 1 to 7 of 7

Help with a formula for frequency

  1. #1
    Registered User
    Join Date
    04-10-2018
    Location
    Ontario
    MS-Off Ver
    2016
    Posts
    24

    Help with a formula for frequency

    Hi Everyone,

    I'm looking for a formula I can use to populate columns H,I,J,K with the number from columns B,C,D,E that appears most frequently under each 3 digit PC. Any help would be greatly appreciated.

    Thank you
    Attached Files Attached Files
    Last edited by Abell; 03-19-2019 at 01:27 PM.

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,903

    Re: Help with a formula for frequency

    Would you clarify your request please and add some typical results.

    As far as I can see there is only ONE number e.g. 3090145 in the case of AOA for each PC number so I don;t understand wat you mean by the most frequent number.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    04-10-2018
    Location
    Ontario
    MS-Off Ver
    2016
    Posts
    24

    Re: Help with a formula for frequency

    For some like A0A it is only one number so just pulling that number 3090145 is fine. There are other 3 digit codes where for example there might be 5 different Rep Numbers. I want it to pull the Rep number that shows up most frequently under that 3 digit code.

  4. #4
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    HOME: Excel 2007 - WORK: Excel 2013
    Posts
    7,007

    Re: Help with a formula for frequency

    "The number...that appears most frequently..."

    What happens if it's a draw within that the 3-digit PC under that heading, e.g. 309145 appears 5 times under A0A and 2000145 also appears 5 times.
    What would you want to see then?
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  5. #5
    Registered User
    Join Date
    04-10-2018
    Location
    Ontario
    MS-Off Ver
    2016
    Posts
    24

    Re: Help with a formula for frequency

    Sorry I should have clarified better. I only want each formula looking at each specific column. IE for A0A the reps would be 3090145,2000145,2000145,3873131 in columns H,I,J,K. If it happens to be a draw under column B if possible leave the cell blank.

    Thank you

  6. #6
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    5,613

    Re: Help with a formula for frequency

    Does this right?
    H2 drag across and down
    =MODE(INDEX(B$2:B$26574,MATCH($G2,$A$2:$A$26574,)):INDEX(B$2:B$26574,MATCH($G2,$A$2:$A$26574))+{0,0})

  7. #7
    Registered User
    Join Date
    04-10-2018
    Location
    Ontario
    MS-Off Ver
    2016
    Posts
    24

    Re: Help with a formula for frequency

    That does it. Thanks very much

+ 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. Replies: 3
    Last Post: 01-21-2016, 02:23 PM
  2. Replies: 3
    Last Post: 02-11-2014, 05:36 PM
  3. [SOLVED] frequency formula
    By Elainefish in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-09-2013, 04:04 AM
  4. histograms - frequency and relative frequency?
    By confusedstudent in forum Excel General
    Replies: 2
    Last Post: 02-08-2006, 04:25 AM
  5. [SOLVED] Frequency Formula
    By Rich Z in forum Excel General
    Replies: 2
    Last Post: 09-13-2005, 05:05 AM
  6. [SOLVED] Using Frequency formula
    By jimbo in forum Excel General
    Replies: 4
    Last Post: 08-31-2005, 05:33 AM
  7. Frequency formula
    By Curious in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-12-2005, 05:06 PM

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