Same conclusions and questions as Adrian has. It seems to work as intended. Maybe you can tell us which line doesn't give the 'right' number and what ...
Back from holidays I visit the Forum again every day from now on. Lot's of interesting topics, mostly solved already. Is the file Paul talks about ...
Trying to figure this out, but I´m afraid it isn´t possible. I thought maybe a workaround could be to use ´view´ and then ´custom views´, cause you...
Hm. Overwriting should not be a problem. You can try first deleting the data that isn't proper anymore and after that putting in the new data (and ...
Maybe you can provide an example file? There are more things to know why this doesn't work properly. Depends also on where and how you used your Offse...
I sometimes encounter problems like this when I use files from an older and/or (don't know if it's always and) other language version of Excel. So ...
Hi Philip, this is awesome! Nice step first to see how it would look like, possible to change some settings and nice print lay-out! I printed this ...
Hi Rathanak, What's different from your post and the answers given there (such as )?
Hi Sunny, thanks for your extra effort providing us with the Excel-sheet. I see how you worked up towards the complete formula. As said: the wor...
SunnyKow wrote: "I hope this helps to explain the formula given." This sure did help Sunny! Thanks a lot sharing this with me/us. I didn't know ...
Hi Sunny. Nice solution! But what would it help when you try to explain some things about this formula. Why this solution? How do you build this up an...
Thanks Phil! That's a clever workaround for the moment. Didn't thought of that. Hope your people getting the functionality working and assume you'l...
The attachment helps a lot Bob (I would have asked for it). Unfortunately I can't find what's wrong. Tested several things. It looks like you made the...
Undoubtly there must be a clever formula for that, but maybe something easy as this example can help you further? (I hope you get to see the file, ...