remove zero

  1. M

    Help With Formula Showing Value

    Hi All, I am currently using an index/match formula to bring score data from one table to another. The problem I am having is that it is assigning a zero value in fields that have no data. This is causing an issues when I am pivoting out the column using that data. We have two set of...
  2. L

    Return blanks instead of zeros if no data in column (MINIFS formula)

    I currently am using this formula: =MINIFS(AH$71:AH$120,D$71:D$120,$D$4) However, if there is no data in cells AH71:AH120, then it returns a zero. I want to formula to return blanks rather than a zero. How can I adjust my formula to do so? Thanks in advance.
  3. S

    Remove characters before and after, remove zero and add letter

    <colgroup><col span="5"></colgroup><tbody> <colgroup><col span="4"></colgroup><tbody> This is what I have: 000901000017 00068794 0 CA 000901000024 00014544 0 CA 000901000079 00068796 0 CA 000901002004 00050853 0 CA 000901016315...

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