balls

  1. S

    Adding Cricket Overs with VBA with parameters

    Hi In Cricket Sports there are 6 legal balls a bowler bowls towards the batsman. Those 6 balls are called an over. So, the sequence of the balls are counted as follows. 1 ball = 0.1 overs 2 balls = 0.2 overs 3 balls = 0.3 overs 4 balls = 0.4 overs 5 balls = 0.5 overs 6 balls = 1 over 7 balls =...
  2. R

    Whole #s as a result dividing by 3

    Hi All I want to divide a number by 3 and distribute it in whole numbers. I found examples online using a bucket and tennis balls but haven't been able to translate it. A1=22 tennis balls, and B,C,D are buckets of tennis distributed into whole numbers B1=8 C1=7 D1=7 Your help is greatly...
  3. T

    Lookup total and subtract with VLOOKUP

    Hello, I hope someone can help me. this has been driving me crazy for a few weeks. I have 2 sheets, one named inventory and another named orders. on the orders sheet I want to be able to do a vlookup to the inventory tab and display the qty in stock, but then if the same item is listed on...
  4. T

    Probability Formula?

    There are 3 balls in a bag, one red, two blue. Therefore, there is a 33.33% (Cell A1) chance of picking the red ball, and a 66.66% (Cell A2) of picking a blue ball. Would there be a formula to calculate the probability in a 'Best of X' race? So for instance, what would be the probability of...
  5. L

    Adjusting values based on rankings

    I am having trouble building a measure to accomplish what's described below. I am working with the following scenario: - There are 2 types of balls: green and red. - There are 3 types of buckets: A, B and C. The balls are randomly dropped inside the buckets. The table below shows how many...
  6. B

    Calculated Item Causing issues in Pivot Table

    I have a set of data that is 4 items divided into 2 categories and then monthly sales over 2 years. An example of the data is: <tbody> Category Item Description Month Year Units Sold Revenue Balls Basketball April 2016 20 160 Balls Baseball April 2016 40...
  7. C

    Conditional Formatting to Create Harvey Balls or other icon set

    Hi All, I am using Excel 2010 and need a little help creating Harvey Balls or other icon set. I am using the =Right(E2,1) formula to pick a number from cell E2. I am doing the same to lift data from cell F2, G2, H2 and I2. I am then attempting to use conditional formatting to show the Harvey...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top