Last seen: Jul 6, 2025
Hello, Check out this function. Br, Anders
Hello, I am sorry, I didn't think it was possible, but I am even more confused. Your cell references does not match with what is shown in your samp...
Hello, Are you sure Excel is the best tool for such tasks? You can of course use Excel, but there are more adequate tools out there, just search...
Hello, I am sorry, I don't understand what it is you want to achieve. Can you elaborate more? Br, Anders
Hello, Yes, the data also seems to be part of a training excercise. You can join data using relationships and Pivot, as Mynda writes in her reply, ...
Hello, Have you tried using a Pivot Table? That would be my option to use. Br, Anders
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...