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 somethin...
I suppose I could use the vlookup technique you previously used, Sunny. And they could enter their mg dosage. Then I could just narrow my vlookup to j...
Sunny, Your result still worked out well. That’s exactly what I was trying to do. That left over day still worked out well. I’ll try to explain a ...
Anders, I’ll check it out when I get home, thanks for the reply! I know I’ve made this difficult enough as it is, but I wonder if you guys know ...
Sunny, You're absolutely brilliant!! I see it doesn't work for Sunday, but that's ok. The rest is amazing! Thank you so much! Its perfect! ...
Sunny, That is exactly what I'm after, except I need to be able to round to the nearest 0.5mg for each day. So if my weekly dose is 30.5mg My day...
Here is the link to the google docs sheet. Hopefully this works, if there's better way to upload just the xls file, I'm not sure of it! If you loo...
Sunny, I will try to upload my file later today!