Shg.

While this is excellent and is on par with what I had on mind, I have a few questions...
a. Will I be able to change the values for the ranges?
b. Am I expected to drag and drop the formula or is it auto populated? Cos I don't understand the F column and its functions....

I am glad that you nailed my requirement....

Thanks again..