If I may trouble you again Sir I am trying to understand how your formula
achieved the desired result and learn from your answer.
I tried highlighting the formulas various factors and pressing the F9 key
to get the result but got stymied with the resultant Excel message that the
€śformula is too long.€ť
So that I may learn, if you have the time and desire would you please
explain how the formula calculates?
I am familiar with the functions Index and Match but do understand how they
work together with their components in your formula.
"Max" wrote:
Welcome, AG. Good to hear that.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"AG" wrote in message
...
Thank you Max.
The formula works perfectly