Forum

Hello, I suggest you work with your data in a tabular format and then use a Pivot Table to summarize the sum per month. https://www.myonlinetrain...

Hello, Actually, the formula provided by Sunny and the formula having CONCATENATE is doing just the same thing. The blog article linked too below g...

Hello, I don't know if there is a template available suitable for your needs, but I usually look here first.

Hello, If you haven't already, do read this article. The blog section is a treasure box.

Hello Kenneth, I try to give you an answer as this is gives me a good training in using Power Query. The steps I used is visible when you choose to...

Hello, I assume you then use the .xls file format. It does have its limitations. The .xls file format only support a limited number of 7 nested fun...

Hello, First link is a simple guide from Office support pages on how to set a printing area. The second link is a blog article here at MOTH describ...

Hello Shawn, Welcome to MOTH. If you haven't already, please take a look at this blog article, it might give you the answer you look for.

Hello, I noticed that Jon Acampora just uploaded such example.

Hello, I downloaded the Protected.xlsm that you have provided Vic. I logged on as User1 and worked fine in sheet SRRV, but there are issues which I...

Hello David, I can at least state for sure that working with data setup in a tabular format will make it a lot easier to work with the data. Here i...

Hello Gary, Yes, it is always good to include some error handling functions, just in case. Great that the formula worked fine for you.

Hello Julie, As Sunny shows very well in his example, you can use AVERAGEIF(S) to avoid zeros. Not sure if you have checked this article, if not th...

Hello, Please read this blog to get to know more about some functions in Excel. Another source for more information is the Microsoft Office suppo...

Hello Danielle, You are welcome. What I find amazing is all the knowledge stored and made available here at MOTH. The blog articles contains lot...