JOIN COLLECT formula
I could use assistance building a JOIN COLLECT formula, I think. Here is what I'm trying to do.
Using the formula =JOIN(COLLECT(rangecriterion_range1criterion1[criterion_range2criterion2...]) , I don't understand what I'm collecting and what I'm joining.
p.s. I already have the -SUMIFS in place to do the math from source to destination.
Here is a screen shot of my source sheet
and my destination sheet
As you can see I'm trying to combine set of leave date, Start Date - End Date, Start Date, etc in each of the appropriate columns (A/L, S/L, M/L). Extra criterion is that if the start date and end date are the same, just enter the start date
Can this even be done?
Thank you for any and all help!
Help Article Resources
Check out the Formula Handbook template!