Results 1 to 10 of 20

Thread: How to calculate best bowling figure (cricket)

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 07-22-2022, 03:59 AM #11
    ahmedleo414
    ahmedleo414 is offline
    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
    Last edited by DocAElstein; 11-02-2024 at 07:03 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Formula To Get Best Bowling Stats From Wickets Taken and Runs Conceded [Cricket Bowling]
    By msiyab in forum Excel Help
    Replies: 7
    Last Post: 06-17-2019, 04:34 PM
  2. calculate sum of three numbers where the answer should be zero
    By ashu1990 in forum Excel Help
    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

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
  •  

Forum Rules