non zero

  1. P

    Quartiles of filtered data not including zeros

    Hi there I have read threads that show me how to find non zero, filtered averages. I want to do the same thing but for 1st, 2nd and 3rd quartiles. Can anyone help please?
  2. A

    How to select the second non zero/blank value in a range?

    Here is an example row of data, with 8 values: 0,[blank],0,1,0,0,[blank],5 We are trying to find a formula that finds the second non zero or non blank value, which in this case is 5. (Ideally this should also be able to be configured to find the third or later non zero non blank value too)...

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