Hi,
I have array formulas to fill the calendar but the times for the dates aren't in sequential order. Can someone please take a look and possibly come up with a solution? I highlighted P22:P25 yellow to show they are not in order.
Thank you
Hi,
I have array formulas to fill the calendar but the times for the dates aren't in sequential order. Can someone please take a look and possibly come up with a solution? I highlighted P22:P25 yellow to show they are not in order.
Thank you
1. Sort using dropdown of cell U3, Smallest to Largest
2. Sort using dropdown in cell W3, Newest to Oldest
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Thanks but I'm not sure what you mean. I did however come up with formula changes on the Calendar. To include the Holidays and Birthdays/Anniversaries I set those times to 12:00 AM and conditionally formatted the text to white on the Calendar range of cells.
In F4:
=IFERROR(SMALL(IF($AB$3:$AB$942=DATE(YEAR(F$3),MONTH(F$3),DAY(F$3)),$Z$3:$Z $942,""),ROW($A1)),"")
In G4:
=IFERROR(INDEX($AA$3:$AA$942,MATCH(SMALL(IF($AB$3:$AB$942=DATE(YEAR(F$3),MO NTH(F$3),DAY(F$3)),$Z$3:$Z$942,""),ROW($A1)),IF($AB$3:$AB$942=DATE(YEAR(F$3 ),MONTH(F$3),DAY(F$3)),$Z$3:$Z$942,""),0)),"")
These are both arrays so they need CTRL+SHIFT+ENTER
Please see the new revision attached.
What?! I can't say it any simpler.
1.
2020-04-08_125238.jpg
2.
2020-04-08_125415.jpg
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.