decide

  1. D

    Subtotal minimum number that isn't zero

    Trying to get the following, but cannot figure the formula to get my desired output described. Subtotal(5,H4:H15) - the minimum number in a filtered list that isn't zero. Likewise, Subtotal(4,H4:H15) - the max number in a filtered list that is below 400 (or whatever I decide) Any thoughts...
  2. M

    Which is less "resource intensive" - "Clear Shape With Text" (ie rectangle) versus "TextBox"

    I have a huge document with tons of these. And I always decide randomly which I will use on a given day. But I bet one of them takes up less space... thoughts? MC
  3. J

    Formula to tell if a point would fall above or below a line in a graph.

    Below is the chart. The numbers that decide where the point plots from are the PI ('T-89 & T-90'!I10) and LL ('T-89 & T-90'!I8)
  4. D

    Using Criteria to decide which range to count

    I am wanting to achieve a countif which will refer to a different cell to decide which column to count. Example: I have data in 8 different Columns, labelled 1-8. I want to count the pieces of information in each column using countifs, however this will depend on the value in A1. (i.e. if I...

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