I just tested the vlookup method and narrowed my vlookup range to 2 cells and tried a few numbers. Doesn't seem as effective, it will give me something likernIf I have 29 as my weekly dosage and I use 2mg and 4mg as my Vlookup integers my results end up looking like this:rnMon - 2, Tue - 2, Wed - 2, Thur - 2, Fri 4, Sat - 4, Sun -9rn rnSo it clumps all of my leftovers at the end of the week rather than spread that extra 9mg out like this: Monday -4, Tue 4, Wed - 2, Thur -2, Friday -4, Sat - 4, Sun - 1  (1/2 of a 2mg tab) .   So I guess for now ill stick with your original suggestion!

Hi Daniel

I have modified my original formulas.

I think it will work for any combination of dosages.

I have included 3 examples.

Do let us know your test results.

Good luck.

Sunny