Forum Discussion
Auto Divide Cell Value to Specified Cells in a Column
In E5:
=IF(D5="Absent",0,QUOTIENT($A$1,$A$2-COUNTIF($D$5:$D$9,"Absent"))+(COUNTIF(D$5:D5,"<>Absent")<=MOD($A$1,$A$2-COUNTIF($D$5:$D$9,"Absent"))))
Fill down to E9.
This is so helpful! How about if I have other values other than "Absent"? How can I add them? I appreciate you so much!
Let's say you also want to exclude Meeting.
Change COUNTIF($D$5:$D$9,"Absent") to (COUNTIF($D$5:$D$9,"Absent")+COUNTIF($D$5:$D$9,"Meeting"))
and COUNTIF($D$5:$D$9,"<>Absent") to
COUNTIFS($D$5:$D$9,"<>Absent",$D$5:$D$9,"<>Meeting")
You can add other options the same way.
Hello, Hans. I got another newbie roadblock. I'd like to set up a workbook in such a way that when I select a month from a dropdown in cell x, the dates along with the values I keyed in every day of those months will autopopulate accordingly. How can I go about doing that? Thank you so much in advance.
In B3:
=DATEVALUE(("1-"&A2&YEAR(TODAY())))
In C3:
=IF(B3<EOMONTH($B$3,0),B3+1,"")
Fill to the right to AF3.
Apply the custom number format mmm-dd to B3:AF3.
- You're amazing, Hans! Thank you so much!