Forum Discussion
Help with formulas
Thank you, you are a genius and it works on your document, but it will not allow me to copy it over to my document for some reason?
Also the H1 and H2 function adds 1 in the end boxes rather than a 0.5 or half.
Any ideas. Sorry to ask more questions, but I sent the original document and not the one I had already adapted to the business
In the sample workbook, columns NT and NU simply count the number of cells with H1 and H2, respectively.
In columns NJ and NK, these count for 0.5.
So for example if there are three cells with H1 in row 8 (and no other cells with codes), cell NT8 will show 3, but cells NJ8 and NK8 will show 1.5.
It's impossible for me to know why it doesn't work in your own workbook without seeing (a copy of) it.
Dear Hans
Apologies for the delay in responding - I couldn't get back to this.
I should have attached the document I actually use, which would make more sense.
I thought I would be able to copy over what you did to sort out the issue with the sickness days, but it does not seem to copy over. Any further suggestions. This is the actual chart I current use.
Kind regards
Nicola MorrisSee the attached version. I had to save it under another name since your workbook opens read-only.
- Hans, you are a legend, how you did this I have no idea, I fumbled my way through for about 3 hours. Thank you for sorting it out.
Kind regards
Nicola