non

  1. O

    VBA To identify the non-match between a pivot table and a column of data

    Hi all! I am trying to write VBA code to execute the following (visual screenshot attached) If the value in column C of the pivot worksheet isn't found within column G (specific to the material in column B), I need to update the qty in the Overview tab for the missing size to 0. For example...
  2. srizki

    =if(and("", formula needed

    I need a formula, that see in column G, if the corresponding cell in G is empty, it leaves empty, if the first digit is 4 then the formula should populate “BIL”, (no quotes), if the first digit is 7 then “NON”. So there are three condition, if it is empty, leave empty, So the formula will be...

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