Forum

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...

Hello Gary, I used an INDEX & MATCH formula to get the value for cell I2. Use conditional formatting on the cell to catch the correct colour ba...

Hello, Seems likely to be some macro code that causes this. Did a search and found this topic in a different forum. Perhaps it can help you forward...

Hello, You need to use VBA to build such solution, but just so you know, it is not secure as it can be cracked easily. I just did a web search for ...

Hi, Something like this?

Hi Dave, I have ungrouped the date and have instead formatted the view using with ordinary number formatting. Even though you see the dates in the ...

Hello Jay, I think you will find the answer in this blog post.

Hello David, I am not sure I understood your question to the fully, but let's do a try. Please see attached file for an example. I have put your...