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

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

2. ## Re: Top 3rd, Middle 3rd or Bottom 3rd???

Try this, copied down!

Formula:
`Please Login or Register  to view this content.`

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

Another way:

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

4. ## 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"))

5. ## Re: Top 3rd, Middle 3rd or Bottom 3rd???

Originally Posted by TMS
Try this, copied down!

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

Bob

6. ## Re: Top 3rd, Middle 3rd or Bottom 3rd???

Originally Posted by HansDouwe
Another way:

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

7. ## Re: Top 3rd, Middle 3rd or Bottom 3rd???

Originally Posted by josephteh
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. ## 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. ## Re: Top 3rd, Middle 3rd or Bottom 3rd???

thank you so much all.

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

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

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