Page 2 of 2 FirstFirst 12
Results 11 to 20 of 20

Thread: How to calculate best bowling figure (cricket)

  1. #11
    Junior Member
    Join Date
    Aug 2021
    Posts
    6
    Rep Power
    0
    Quote Originally Posted by DocAElstein View Post
    Thanks, Chidambaram3983, for adding your alternatives.
    Just for comparison, I have added them to my file

    Alan
    I have actually found a much simpler way to do it.

    Code:
    =MINIFS(D2:D21,E2:E21,MAX(E2:E21))&"/"&MAX(E2:E21)
    no need for Macros, this does exactly what I was looking for


    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://www.youtube.com/watch?v=XQAIYCT4f8Q&lc=UgwTUdEgR4bdt6crKXF4AaABAg. 9xmkXGSciKJ9xonTti2sIx
    https://www.youtube.com/watch?v=XQAIYCT4f8Q&lc=UgwWw16qBFX39JCRRm54AaABAg. 9xnskBhPnmb9xoq3mGxu_b
    https://www.youtube.com/watch?v=XQAIYCT4f8Q&lc=UgzgWvzV-kvC4TJ8O414AaABAg.9xnFzCj8HRM9xon1p2ImxO
    https://www.youtube.com/watch?v=XQAIYCT4f8Q&lc=UgybZfNJd3l4FokX3cV4AaABAg. 9xm_ufqOILb9xooIlv5PLY
    https://www.youtube.com/watch?v=XQAIYCT4f8Q&lc=UgzgWvzV-kvC4TJ8O414AaABAg.9xnFzCj8HRM9y38bzbSqaG
    https://www.youtube.com/watch?v=XQAIYCT4f8Q&lc=UgyWm8nL7syjhiHtpBF4AaABAg. 9xmt8i0IsEr9y3FT9Y9FeM
    https://www.youtube.com/watch?v=jTmVtPHtiTg&lc=Ugy_RiNN_kAqUvZ8W994AaABAg. 9xhyRrsUUOM9xpn-GDkL3o
    https://www.youtube.com/watch?v=jTmVtPHtiTg&lc=Ugy_RiNN_kAqUvZ8W994AaABAg
    https://www.youtube.com/watch?v=QjEWAJ3d-jw&lc=UgxJLVpwY8fIla7G-pN4AaABAg.9BLeCWVhxdG9wgNsaS3Lp1
    https://www.youtube.com/watch?v=QjEWAJ3d-jw&lc=UgxJLVpwY8fIla7G-pN4AaABAg.9BLeCWVhxdG9wgR1EPUkhw
    https://www.youtube.com/watch?v=QjEWAJ3d-jw&lc=UgxJLVpwY8fIla7G-pN4AaABAg.9BLeCWVhxdG9wgNe_XC-jK
    https://www.youtube.com/watch?v=QjEWAJ3d-jw&lc=UgxJLVpwY8fIla7G-pN4AaABAg.9BLeCWVhxdG9wgNPOdiDuv
    https://www.youtube.com/watch?v=QjEWAJ3d-jw&lc=UgxJLVpwY8fIla7G-pN4AaABAg.9BLeCWVhxdG9wgN7AC7wAc
    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    Last edited by DocAElstein; 12-14-2023 at 02:58 AM.

  2. #12
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,422
    Rep Power
    10
    Thanks a lot for coming back and adding another solution.
    ..."the more the merrier" ...
    In Excel often ..."there's more than one way to skin a cat."

    It's very helpful when learning to see alternatives, IMO

    Alan

    ( BTW the first solution from Chidambaram3983 was a formula similar to yours, I think. But I am not too clued up on formula solutions. It looks similar at first glance

    Often you can use a UDF ( User Defined Function) with your formula, or a similar one, in it to simplify things further as it typically reduces what you have in the spreadsheet.
    ( Although in the case of the UDF given to you by Chidambaram3983, he did a seperate alternative solution. ) )
    Last edited by DocAElstein; 07-22-2022 at 12:45 PM.

  3. #13
    Junior Member
    Join Date
    Aug 2023
    Posts
    1
    Rep Power
    0
    Is it possible to pick best bowling figure, if it like 3/45, 4/40, 4/34 ... without separate section for wicket and runs...

    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://eileenslounge.com/viewtopic.php?p=318868#p318868
    https://eileenslounge.com/viewtopic.php?p=318311#p318311
    https://eileenslounge.com/viewtopic.php?p=318302#p318302
    https://eileenslounge.com/viewtopic.php?p=317704#p317704
    https://eileenslounge.com/viewtopic.php?p=317704#p317704
    https://eileenslounge.com/viewtopic.php?p=317857#p317857
    https://eileenslounge.com/viewtopic.php?p=317541#p317541
    https://eileenslounge.com/viewtopic.php?p=317520#p317520
    https://eileenslounge.com/viewtopic.php?p=317510#p317510
    https://eileenslounge.com/viewtopic.php?p=317547#p317547
    https://eileenslounge.com/viewtopic.php?p=317573#p317573
    https://eileenslounge.com/viewtopic.php?p=317574#p317574
    https://eileenslounge.com/viewtopic.php?p=317582#p317582
    https://eileenslounge.com/viewtopic.php?p=317583#p317583
    https://eileenslounge.com/viewtopic.php?p=317605#p317605
    https://eileenslounge.com/viewtopic.php?p=316935#p316935
    https://eileenslounge.com/viewtopic.php?p=317030#p317030
    https://eileenslounge.com/viewtopic.php?p=317030#p317030
    https://eileenslounge.com/viewtopic.php?p=317014#p317014
    https://eileenslounge.com/viewtopic.php?p=316940#p316940
    https://eileenslounge.com/viewtopic.php?p=316927#p316927
    https://eileenslounge.com/viewtopic.php?p=316875#p316875
    https://eileenslounge.com/viewtopic.php?p=316704#p316704
    https://eileenslounge.com/viewtopic.php?p=316412#p316412
    https://eileenslounge.com/viewtopic.php?p=316412#p316412
    https://eileenslounge.com/viewtopic.php?p=316254#p316254
    https://eileenslounge.com/viewtopic.php?p=316046#p316046
    https://eileenslounge.com/viewtopic.php?p=317050&sid=d7e077e50e904a138c794e1 f2115da95#p317050
    https://www.youtube.com/@alanelston2330
    https://www.youtube.com/watch?v=yXaYszT11CA&lc=UgxEjo0Di9-9cnl8UnZ4AaABAg.9XYLEH1OwDIA35HNIei0z-
    https://eileenslounge.com/viewtopic.php?p=316154#p316154
    https://www.youtube.com/watch?v=TW3l7PkSPD4&lc=UgwAL_Jrv7yg7WWC8x14AaABAg
    https://teylyn.com/2017/03/21/dollarsigns/#comment-191
    https://eileenslounge.com/viewtopic.php?p=317050#p317050
    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    Last edited by DocAElstein; 08-27-2024 at 06:48 PM.

  4. #14
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,422
    Rep Power
    10
    Hi Pinch hitter,
    Welcome to ExcelFox
    I can’t remember much about this Thread, and still I don’t know too much about cricket either.

    The simple answer is that most likely in Excel with a formula or VBA we could manipulate data to get any result you want. Most likely there would be almost an infinite ways to do it as well.
    To give you a specific solution or more detailed answer attempt I would need a small sample of your data and an example of the result you want to get.

    (Or, if an answer here is close to what you want, (coding or formula), then tell me which one, and tell me what you want differently.)
    Alan

  5. #15
    Junior Member
    Join Date
    Aug 2021
    Posts
    6
    Rep Power
    0
    I've got a new problem I need to figure out but can't quite do it.

    Now I'm trying to calculate the highest score for a player. Here is an

    Screenshot 2023-11-25 221209.jpg

    Here is the code

    Column N

    Code:
    =IF(AND(MAXIFS($C$2:C2,$A$2:A2,A2)=C2,H2=1),MAXIFS($C$2:C2,$A$2:A2,A2)&"*",MAXIFS($C$2:C2,$A$2:A2,A2))
    Now the issue is, I need to have the * next to the high score if they player was Not Out (column H =1)

    ODI Bat.xlsx

  6. #16
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,422
    Rep Power
    10
    Hi there, welcome back!

    I won’t be able to help here, as I still mostly do VBA stuff. Formulas which I think you are interested in are not really my thing, especially things like MAXIFS , since they are only available in Excel since 2019. I tend personally to favour older stable Excel versions. (Bare in mind that if you figure out a solution using MAXIFS, then you can only use it in Excel versions of 2019 + )

    Alan
    Last edited by DocAElstein; 11-26-2023 at 11:07 PM.

  7. #17
    Member p45cal's Avatar
    Join Date
    Oct 2013
    Posts
    94
    Rep Power
    12
    You seem to have done it in the ODI Bat.xlsx file you attached. Is there something missing?
    One problem may be that you'll want to use those high scores as numbers (to do calculations or something else numeric) and those with the asterisk can't be; they're text.
    In the attached I added a column O (headed High Score b) that is a shorter version of your formula, although all values in that column are text.
    I also added a column P (headed High Score c). All these values can be treated as numbers. I used conditional formatting to add an asterisk if column H contained a 1.
    What version of Excel are you using?
    Attached Files Attached Files

  8. #18
    Junior Member
    Join Date
    Dec 2023
    Posts
    2
    Rep Power
    0
    I've provided the template file for your reference.

    The concept is to identify the maximum value in column E (wickets) for a given player's statistics. If a player has only one match where they took 3 wickets (for instance, the highest in our example), we would then look at the corresponding value in column D of that same row to determine the number of runs allowed by the player. In this example, it would be 70. Consequently, the results for the best bowling figure would be represented as 70-3.

    In another scenario, if a player has taken 3 wickets in two matches, we would seek the minimum value in column D. In the attached picture, the minimum is 32. Therefore, in this case, the results for the best bowling figure would be displayed as 32-3.

    For your convenience, I have highlighted on sheet 3 where these results should be displayed.

  9. #19
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,422
    Rep Power
    10
    Thanks, explorerather, for adding a solutions, and welcome to ExcelFox

    Just one thing…..
    Quote Originally Posted by explorerather View Post
    I've provided the template file for your reference……..
    I don’t see any file anywhere??




    Alan
    ….If you are my competitor, I will try all I can to beat you. But if I do, I will not belittle you. I will Salute you, because without you, I am nothing.
    If you are my enemy, we will try to kick the fucking shit out of you…..
    Winston Churchill, 1939
    Save your Forum..._
    _...KILL A MODERATOR!!

  10. #20
    Junior Member
    Join Date
    Dec 2023
    Posts
    2
    Rep Power
    0
    Hello,
    Calculating the best bowling figures in cricket involves understanding and analyzing a bowler's performance in a particular match. The bowling figures are usually represented as overs, maidens, runs conceded, and wickets taken.
    Thank you.

Similar Threads

  1. Replies: 7
    Last Post: 06-17-2019, 04:34 PM
  2. Replies: 1
    Last Post: 04-24-2013, 04:34 PM
  3. Calculate the Hours
    By leopaulc in forum Excel Help
    Replies: 2
    Last Post: 02-27-2013, 02:51 PM
  4. Runtime Error 481 invalid figure when PNG
    By Tony in forum Excel Help
    Replies: 0
    Last Post: 02-12-2013, 12:59 AM
  5. Add Overs in Cricket
    By MrDelhi in forum Excel Help
    Replies: 1
    Last Post: 07-15-2011, 09:40 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •