+ Reply to Thread
Results 1 to 10 of 10

Top 3rd, Middle 3rd or Bottom 3rd???

  1. #1
    Registered User
    Join Date
    10-15-2020
    Location
    Scunthorpe, England
    MS-Off Ver
    365
    Posts
    20

    Top 3rd, Middle 3rd or Bottom 3rd???

    Hello again Excel geniuses,

    If you would be kind enough to help me solve this final challenge, my project will be complete.

    Incidentally, I'm a volunteer who runs a snooker league handicap system and this spreadsheet when completed and working properly is going to save me hours (if not days) of inputting time, so thank you in advance.

    The challenge

    Column A contains provisional handicaps.

    I need a formula for Column B which returns T, M or B, to show if the provisional handicap (Column A) is in the top third, middle third or bottom third.

    As always, many thanks for looking at this for me.

    Bob
    Attached Files Attached Files

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    45,004

    Re: Top 3rd, Middle 3rd or Bottom 3rd???

    Try this, copied down!

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,465

    Re: Top 3rd, Middle 3rd or Bottom 3rd???

    Another way:

    Try in B5 and copy down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,160

    Re: Top 3rd, Middle 3rd or Bottom 3rd???

    Using PERCENTILE spill formula in cell B5: =IF(A5:A92<=PERCENTILE(A5:A92,1/3),"B",IF(A5:A92<=PERCENTILE(A5:A92,2/3),"M","T"))
    Last edited by josephteh; 03-27-2024 at 11:39 AM.

  5. #5
    Registered User
    Join Date
    10-15-2020
    Location
    Scunthorpe, England
    MS-Off Ver
    365
    Posts
    20

    Re: Top 3rd, Middle 3rd or Bottom 3rd???

    Quote Originally Posted by TMS View Post
    Try this, copied down!

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Once again - thank you - this is perfect.

    Bob

  6. #6
    Registered User
    Join Date
    10-15-2020
    Location
    Scunthorpe, England
    MS-Off Ver
    365
    Posts
    20

    Re: Top 3rd, Middle 3rd or Bottom 3rd???

    Quote Originally Posted by HansDouwe View Post
    Another way:

    Try in B5 and copy down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    ...thank you for getting back to me

  7. #7
    Registered User
    Join Date
    10-15-2020
    Location
    Scunthorpe, England
    MS-Off Ver
    365
    Posts
    20

    Re: Top 3rd, Middle 3rd or Bottom 3rd???

    Quote Originally Posted by josephteh View Post
    Using PERCENTILE spill formula in cell B5: =IF(A5:A92<=PERCENTILE(A5:A92,1/3),"B",IF(A5:A92<=PERCENTILE(A5:A92,2/3),"M","T"))
    ...thanks for getting back to me so quickly

  8. #8
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    45,004

    Re: Top 3rd, Middle 3rd or Bottom 3rd???

    You're welcome.



    You may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

  9. #9
    Registered User
    Join Date
    03-09-2024
    Location
    india
    MS-Off Ver
    Microsoft 365
    Posts
    2

    Re: Top 3rd, Middle 3rd or Bottom 3rd???

    thank you so much all.

  10. #10
    Registered User
    Join Date
    03-09-2024
    Location
    india
    MS-Off Ver
    Microsoft 365
    Posts
    2

    Re: Top 3rd, Middle 3rd or Bottom 3rd???

    It depends on the context. In terms of performance, aiming for the top 3rd is usually desirable, indicating excellence or achievement. However, being in the middle 3rd can also signify stability or average performance, which may be appropriate depending on the situation. The bottom 3rd typically suggests room for improvement or areas that need attention to move up.

+ 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. Calculating the average(s) of top, middle and bottom quarter values
    By AndrejLav in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-19-2015, 10:30 PM
  2. Identifying top 33%, middle 33%, and bottom 33%
    By eaflynn in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-18-2013, 09:15 PM
  3. Formula to return value for top, middle, bottom % values
    By brianjluke in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-13-2013, 03:05 PM
  4. Calculations for First 33%, Middle 33-67%, Bottom >67% of cells
    By DexterG in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-07-2013, 11:28 AM
  5. Replies: 1
    Last Post: 06-13-2012, 11:07 PM
  6. Move Caption In Textbox to Middle and bottom
    By Macdave_19 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-11-2008, 04:20 AM
  7. Get Top X,Middle Y,Bottom Z percent Records
    By Bala in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-02-2006, 08:10 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