1/5/18

  1. B

    VBA to check if all names in a list have been processed

    Hi, I have a payroll spreadsheet and we have had instances where employees have not been processed for a week because they have been on holiday and so have not submitted a timesheet. I therefore want to put in some code to run when the workbook is shut to check if all the names in the 'Lists'...
  2. B

    index match or offset?

    I am trying to type in a name in column D, and have the data from column B (for that name), generate in ascending order in column E. Any ideas? Is it an index match formula? <tbody> A B C D E F 1 Matthew 1/1/18 37 Mark 1/1/18 45 2 Mark 1/1/18 45 Mark 1/5/18 41 3 Luke 1/1/18 52 Mark...
  3. C

    conditional formatting dates

    Hi All, ok I need cells to highlight when they are 90 days from expiring and continue to be highlighted until 1 day after they have expired, so say the date in the cell is the 1/5/18 and so when we actually get to the 31/1/18 I want it to turn yellow and then when we actually get to the 1/2/18...

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