Forum

Hello Dinesh, May I suggest you to consider taking the Excel for decision making course that is available here at MOTH? I haven't taken it myself, ...

Hello Julie, A general answer is to use Power Query for this.

Hello Charlie, Thank you for the additional explanation, I think I have grasped the picture now. As I still assume you need to copy and paste this ...

Hello Charlie, I assume you want some help with TIMES.xls. I also assume that what we see in TIMES.xls is the report output from your time registra...

Hi, It is a nice trick Velouria, I had to play around a little to understand what it does. This is why I like this forum, you get to learn new ways...

Hi Anne, It all depends on how experienced your customer is with creating and using scripts, for example VBA, Command or PowerShell scripts. With s...

Hello, As you mentions, the net value is calculated as: = Order Value - ((One Time Cost * Quantity of Terminals) + (Monthly Cost * (Nr of Months * ...

Hello Tina, What you are showing is a service from a SQL server, also refered to as SSRS. You can read more about it from the link below. You would...

Hello, I am sorry, I am not so familiar with the M language, but perhaps there can be some useful information in these pages. But I was thinki...

Hi Anne, You should be able to change the source folder path using the Advanced Editor in Power Query Editor. You can also change source path from ...

Hi Brittany, If H2 only has Y or N as parameters then you just need to do as Phil suggests. But if H2 is to have more inputs than just those two yo...

Hi David, In the blog section you can search for Power Query and you will find good information and examples on how to work with that tool.<-- i...

Hi Paul, Have you considered to use a Pivot Table instead? Just took a glimpse of your file and I do think you should consider to rearrange your da...

Hello, I am looking in the file uploaded by Sunny. You just need to add one extra condition in the formula in cell H4. Current formula is: =IF([...