+ 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
    35

    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 - RIP 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
    29,464

    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

    RIP - d. 06/10/2022

    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
    35

    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
    Excel 2019
    Posts
    7,062

    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
    35

    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
    7,211

    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
    35

    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. 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