+ Reply to Thread
Results 1 to 3 of 3

Ranking, Top 10 Best Cricket Bowling Figures

  1. #1
    Registered User
    Join Date
    08-26-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    14

    Question Ranking, Top 10 Best Cricket Bowling Figures

    Hello.

    I need to rank/sort for Top 10 Best Bowling Figures, from a list of 15, for cricket using formulas not VBA. Column C contains the wickets and runs given which is what I need to sort pulling the position and name at the same time to end up in final columns Col E, F, G. ("5-50" represents "wickets-runs")

    In the sheet attached I would need the highest number before the "-" at the top, but then the lowest number after the "-", (lowest runs given), displayed with it at the top also.

    Thanks in advance for your help. Hope this makes sense.

    Nigel.
    Attached Files Attached Files

  2. #2
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Essex, UK
    MS-Off Ver
    various
    Posts
    2,078

    Re: Ranking, Top 10 Best Cricket Bowling Figures

    using your sample file (and assuming XL2007) - one way:

    first, identify row for rank by prioritising bowling figures, then name etc..

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    then modify your table to use values in Col I, e.g.

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    08-26-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Ranking, Top 10 Best Cricket Bowling Figures

    Perfect! thanks for this again.

+ 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. Bowling Averages for cricket
    By The Half Back in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-31-2016, 10:13 AM
  2. Need help with cricket: Best Bowling figures
    By sirdon in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-21-2015, 07:52 PM
  3. Need help with displaying cricket best bowling figures
    By sirdon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-17-2015, 04:26 PM
  4. Need help with displaying cricket best bowling figures
    By sirdon in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-17-2015, 03:57 AM
  5. [SOLVED] Cricket Bowling stats
    By TurKnJD in forum Excel General
    Replies: 3
    Last Post: 07-25-2013, 01:43 AM
  6. Replies: 0
    Last Post: 09-27-2012, 02:25 PM
  7. Best Bowling Figures
    By kasablur in forum Excel General
    Replies: 7
    Last Post: 10-06-2011, 08:35 AM

Tags for this Thread

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