Good Afternoon,
I have to manage a project and to monitors the employees' holidays for the next 6 months
Here is an example of what i'd like to achieve
I've actually manage to do it with either both a SUMPRODUCT and an INDEX/MATCH function with a similar formula to the one displayed below
but the issue is that it's a realllly, really heavy one, as I have to handle a bigger data range.
I also have some vba skills but the only way i've found to improve it so far is just to copy paste every results as values to avoid it to be that big (the issue is only splited in smaller chunks and it doesn't change that much).
I wondered if you could help me with a more efficient way to do it, please
Thank you very much,
Picsou
Bookmarks