turning

  1. W

    Autofilter Default

    I have a sheet that goes back some years. Its a pain to view old data so I auto filter it to the current month. But other ppl access it to and mess up the filter. I am now turning off the filter at close and back on when opening. How can a set the filter to only show the current months...
  2. A

    Proper User of Turning DoCmd.SetWarnings

    Hi all, Just a question, no real specific issue (at the moment). What are the best practices for turning DoCmd.SetWarnings to True vs. False? I've seen some programmers set it to false, run a couple lines of code, then set it back to true, and do that repeatedly throughout a program. My...
  3. S

    IF's OR's and Networkdays

    Hi All, Could someone please assist me in turning this into one statement, please. =IF(I2="Remote Installation",NETWORKDAYS(F2,J2) OR =IF(I2="Engineer Installation",NETWORKDAYS(F2,K2)
  4. G

    HELP_POWERPIVOT DAX RANKX Function

    Hi I need some help for issue with RANKX function with DAX. (I tried learn it from net, but when i populate in my data table, it does not work. - My data source : I have only one source table in the model. - I need Rank of Product in one column and Rank of Product with Material in another...

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