u/AUserNameOr2

Missed 5 (6 today) days of Lupin and I'm on my period ~5 days early. What do I do?

I normally take this every day at 7PM, but I've been busy the past couple of days and am bad at reminding myself of any daily activities in general. My period ended up starting yesterday since I missed the pills, so I've started about 5 days earlier than I normally would.

Instructions tell me to take 2 if I miss one day, 3 if I miss 2 days, and for 4 days I take 2 on the first new day, 2 after that, and then back on schedule. Nothing about 5 or more days, though. The last full pill I have is Tuesday, so I would need to catch up on 7 pills. How many should I take when?

reddit.com
u/AUserNameOr2 — 3 days ago

I'm making a list that tracks when certain members post things on specific days listed, but I can't figure out how to get the column to automatically sort the values by the ranks of the people listed. For example, I make a new row for a new person, but I still want them to be included in the function too. On top of that, when someone runs the function, it should sort everything B4 onwards by the order listed. How would I make a function that does that? I had this but I keep getting shown several errors when trying to actually use it.
=ARRAYFORMULA(SORT(B4:B60,MATCH(B1:B60,{"orca.","mura.","lepr.","ring.","spot.","cro.","sea.","ray.","swa.","vms.","str.","bun.","gws.","thr.","whl.","brs.","nrs.","flp.","vmp.","ang.","wlf.","arf.","hwk.","pol.","ssh.","png.","nar.","cmj.","iso.","rib.","fur.","sel.","hrp.","juv.","nur.","pup."},),1,b4:b60,1))

I also should clarify I haven't really used spreadsheets in such an advanced manner before, so I might need to get told how to actually create the formula.

reddit.com
u/AUserNameOr2 — 12 days ago