Thank you Shin. That helps
You are very welcome.
I have a further question in continuation of the previous discussion. With the help of the formula you have provided, I was able to avoid the issue of duplication. However now I need to determine warranty to sales ratio on a Months In Service perspective, where I am getting inaccurate results on machine sales. Attached is a detail presentation and the packaged work book. Can you help?