Forum

Hello, As you have posted this in the Power Query section, do you want a PQ solution or do you want a standard Excel formula using VLOOKUP? The ...

Hello, Lots of information and free, check out Microsoft Docs library.

Hello, I have looked up on this topic and it seems it is a lot more difficult to get what you want using Power Query. Although it seems doable but ...

Hello, I am afraid I don't understand what you are looking for here. You write "Need to find the overlapping dates", what do you mean by overlappin...

Hello, One way to do it is to add the files to the folder in batches, for example 30 or 40, then update and if no errors, add next batch and so for...

Hello, If you can upload a sample file and describe in text what the logics are. What is it you want as end result?

Hello, It seems to me that you could use IF statements by adding a conditional column. Br, Anders

Hello, Depending on what version of Excel you use, if you use Excel 365 then chances are that you can use the new functions. Here are some good art...

Hello, I am sorry to say that I can't find a working solution that rounds the monthly salary as you want it. Hopefully someone else in this forum k...

Hello, The problem I see with your approach is that you have to break the formula the second month from start, else the monthly salary for the seco...

Hello Muhammad, I don't really understand why you want to add this extra column, because if you don't want to sum the PO Total Amount column, then ...

Hello, I don't really see any rounding issue. As attached picture shows (you might need to save it on your computer to be able to zoom in and see a...

Hello, If you know the time difference between the zones you can easily add or subtract the time difference to your original time. Example: Univ...

Hello Arthur, I have done some changes in your formula, see attached file. The formula is now consistent for all rows and columns and simplified. ...

Hello, I will look into this in more depth later this evening. Br, Anders