I am hoping someone will be able to help.
Attached is a training performance file.
There is already a VBA code, which I managed to make with some support from forums and my little knowledge.
We started a new training topic which is only applicable to some staff and i am finding it difficult to achieve this.
So the VBA formula that currently runs is looking at: The range where the dates are inputted and makes sure that it is within the last 12 months, the date i need the percentage for and the column where leavers are marked.
I need on top of this to have another option where I can select the "Designation" either as a range or as text (range is preferred), to only look at staff that started work after the date I am looking at.
The formula should look at a range of two columns and count the biggest date in a single row, and only count if it is within the last 12 months, then to see if they are marked as leavers, then to see if the designation is correct (Based on what I select), also that the staff start date is less than the date i want the percentage for and give me a percentage for the date.
I would also like a formula without the range to look at dates so that I can use it as my denominator.
Thank You for all your help.