Search results

Thank you for the reply, Chihiro! The problem was generated by a category that was misspelled and I was able to solve the problem. With respect to the type of chart, I totally agree, but this is what the stakeholders are asking for. Thank you again for your time.

Hello, I have a Waterfall chart showing the variances between actual and budget by category. The problem is that the visual automatically includes an "Other" column showing the overall variance between the actual and the budget. I cannot seem to be able to remove this bucket from the visual...

Thank you for the reply!

Thank you for the reply!

Hello, I would like to calculate the 12-month rolling average for each product (Column B) based on the Current Month and Current Year (displayed in cells B1:B2) going backwards - see excel file attached. For example, if the current month is Jun-20 and I want to calculate the 12-month rolling...

Thank you, Bosco!

Thank you, Hui!

Thank you for your kind words and the solution provided, Hui. I believe your formulas work but, in the meantime, I believe I found a simpler solution by using the so called conditional sumproduct - formula included below. It took some further research on the internet, but I believe it provides...

Hello, I have a list of materials purchased in various quantities from various vendors and a separate list of monthly costs for each particular material purchased. My goal is to determine the weighted average cost per unit of purchases from a particular vendor during each month. To do so, I...

Thank you, John! This is exactly what I was looking for. Appreciate it!

John, I just realized that I forgot to include one of the most important criteria. If two purchases were made in the same month, the formula should show the purchase occurred prior to that month as opposed to listing the same month as the previous purchase. I have adjusted the file to show this...

Thank you so much for your help with this, John! The formula works well. Blessings!

Hello, I would appreciate if anyone can help with a formula that would solve the following task. The last purchase of a material at a particular plant was made on 11/30/2018. There were also two other previous purchases (i.e., for the same material & plant) made on 8/25/2018 and 10/5/2018. I...

I agree. Thank you so much for all your help in this matter.

Hi Peter, A helper column with the purchase month is acceptable as well as Office 2016. The lookup for a specific purchase/prior month is not feasible because we are not sure if one existed and/or when exactly it took place. The result is used to assess whether a material was purchased prior to...

Thank you for your reply, Peter! The problem with using =LARGE(MaterialPurchaseDate, 2) is that I receive the next to the last purchase occurrence which maybe in the same month. In my initial request, I did not underscore the fact that I need next to the last MONTH and YEAR of the last purchase...

I have a table with a list of individual material purchases and the date of each purchase. Based on this, I would like to retrieve the next to last purchase of a material. For example, material 123456 was purchased in 1/5/2016, 2/3/2017, and 5/8/2018. Based on the material number, I would like...

You can use a helper column to solve the status. The formula is included below. Also see attachment. =INDEX(A3:E13,MATCH(G3&G4,A3:A13,0),MATCH(E3,A3:E3,0))

Thank you for all your help!

Thank you for your help with this, Peter.

Thank you for your help, John. Can you explain this portion of the formula used? {"<=";"<"}

I need to sum the values corresponding to multiple locations, months, and products until a certain max value is reached. Also, whenever the values corresponding to a certain month and location need only to be "used" partially (that is not the entire Remaining Value) to reach the max value, I...