ranges formula

  1. M

    count/sum of numbers between specific range for 2 different values

    Hi All, So my question is how to show how many numbers fall into a specific range between 2 different numbers: BCDEF5Start numberEnd Number22-3031-4546+62429500733430100848680020943440101027564151011275731511 The yellow part of the table i have calculated manually and entered the numbers need...
  2. H

    Listing Numbers in between a range to a separate column

    Hello, Looking for a VBA script that would extract numbers in a range to a separate column. Attaching a screen-shot of various possibilities of ranges. Below is an explanation of diff set of groupings that would like expanded into individual numbers. \+1234567891[01234567] - Anything in...
  3. A

    Help with this FORMULA PLZZZ

    Column C1= $125, $100 or $75 AND D1 = TRUE then this cell = A1, if not then it is blank. But also if column C1 = $50 and D1 = TRUE then this cell = B1. Not sure how to get this formula to work:confused: <tbody> Away Home $50 TRUE Home Away Home $75 TRUE Away Away Home $100 TRUE Away...

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