Interpolation

Here is my interpretation of using Interpolation for Missing Buckets rolled up into an Excel VBA UDF

This UDF Interpolation Function provides Linear Interpolation of missing buckets with the ability to avoid inflation by rebalancing the values if required. It also allows the use of a Fixed Start value and a Fixed End value with two coefficients to adjust these values further, again, if required

Two Examples are demonstrated