applying

  1. R

    custom sort not applying

    I've recorded a custom sort. The sort works exactly how I want, when manually applied (during record process), but fails to apply when applied by executing recorded vba code; by fail, I mean not applying sort and no error messages displayed. After the code has completed, I can visit the "Custom...
  2. A

    Excel Leave validation

    Hello Everyone , I am trying to create an excel application for leave, I have got the template online and its perfect for me. I want to create a validation while applying leave and need your help for this. While applying for leave the system checks the employee column (Employee are divided...
  3. S

    Applying an Excel formula in VBA

    Hello guys, I need your help. My created a long formula in Excel and I need to convert it to VBA. I've been trying a couple of things, but always failed. Can you please help me? So the formula (for example for cell G50) looks like this...
  4. K

    Applying Multiple Conditional Formatting Rules

    I am applying 4 conditional formatting rules to 184 cells. I figured out how to correctly apply the formula and the colors I want but it is going to take forever doing it one at a time (that's 736 rules). Is there a way to do this more efficiently? The rules for the first cell (O7) are...
  5. W

    Filter date trouble

    I have problems when applying the following code ActiveSheet.Range("$A$1:$B$7").AutoFilter Field:=1, Criteria1:= _ "<01.08.2018", Operator:=xlAnd When the macro activates the filter. All values are filtered and are not visible in the list (values larger, equal and lower than...
  6. M

    (Excel equation) Find last non-zero value in a column. Apply it in the same column. Keep applying it when there's a zero in another column.

    Tried for the D column: #=IF(E5 <= 0, LOOKUP(2,1/($D$4:$D$33<>0),$D$4:$D$33), E5)# I got this answer from this website but I'm unable to make it work properly. The sum in I4 doesn't calculate properly, either. More details of issue in image: Thanks for all your help!

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