Last seen: Mar 8, 2026
Hello, Or you can simplify this and have one table with following structure: Country Name, Property, Profit Br, Anders
Hello, Nothing wrong happening, you are referencing to the cells in the worksheet, not to the data in the table. It is better to add the reference ...
Hello, It looks to me that you want an automated solution using VBA. I am not a good coder, so hopefully someone else can assist you further. I am ...
Hello, Just asking myself why it is so hard to keep things simple. Did not fully understand the accrual part, how much is full month and so for...
Hello, As already mentioned by Mynda, the dates in the file is messed up, from row 2710 to the end of list the date/time value is text, in rows abo...
Hello Redha, That part was no issue to grasp, but your data layout is. Some questions: - Where is the list of all employees? - In your lists you...
Hello, I don’t really understand the data layout you have in your sample file, but it will surely be a tricky one for you to accomplish what you wa...
Hello, An alternative formula to get the date for the first Sunday in the month. Depending on your system date setting you might need to change the...
Hello, Had some spare time which I spent creating an example of using Pivot Tables instead. Perhaps not fancier, but a lot more easier and gives yo...
Hello, Not sure why you separate the data as in your example, just makes things more difficult than needed. Attached file shows one way to go about...
Hello, I would do a repair on the Office installation. If that doesn’t help, do an uninstall and after a computer restart install Office again. If ...
Hello, Thanks for the kind words. Just glad I was able to help. Br, Anders
Hello, Have not checked your latest file. A suggestion: If you have these persons listed in a separete table then you can simply add a new IF state...
Hello, My bad, should have tested the formula on a computer also, worked fine for some reason on Excel app on my tablet. See attached for an exa...
Hello, See attached for an example. I had to change your data a bit, nothing major. Hope this helps you forward. Br, Anders