Hi guys,
Honestly, I'm not so great with array formulas. Kindly look at the attached. I'm trying to generate a unique list of employees that will have holiday days in any given month and group them by month. I was able to devise an array formula, but if you look at it, it only considers one criteria. I need it to consider both criteria, starting date and end date and not just the end date as it doing now.
What can I do guys? Look at the attached there is more info there.
Thanks,
Ron
Last edited by ron2k_1; 09-01-2011 at 09:14 PM.
Ron
Knowledge is knowing that a tomato and pepper are fruits. Wisdom is knowing whether to put these in a fruit salad
Kindly
[1] Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
[2] Mark your post [SOLVED] if it has been answered satisfactorily by editing your original post in advanced mode.
[3] Thank (using the little scale) those that provided useful help; its nice and its very well appreciated
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks