november

  1. L

    Formulae to stop incomplete rows showing a value

    I am trying to stop the non completed rows from filling the response "outstanding" in the empty rows below =IF(F55="","Outstanding ",IFS(F55=D55,"Paid",F55<d55,"under paid",f55="">D55,"Credit")) If I replace the word outstanding with just "", then it doesn't put anything in the empty rows...
  2. S

    Workday Help

    Hello I need to generate a list (A1:A23) of working days (excluding weekdays) for the current month. I am currently using =WORKDAY(startdate,1,) with the startdate reference is in F1, but in that situation the A1 starts with the second working day. example: if I put 1 November 2017, Wednesday...
  3. C

    Collecting information

    I have 38 sections identical to this (Below) and I am trying to collect all the m's for a particular month in this case November the 1st. Is this possible as Countif(s), Sumif(s), sumproduct, index and match do not work please advise? <colgroup><col><col span="26"><col><col...

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