How to evenly distribute data in excel cells ?

Hello

Imagine you have a range of numbers (decimals) from 0-8,7. This range is distributed at two columns with different cells row. The first column consist of 385 cell rows and the other one 878. In need to have the same range of numbers evenly distributed along all cells for the columns, even if that means to interpolate between them and the cell rows of the first column increase to match the number of the cell rows of the second one.

Any help please?

Thank you

Regards
FanIstas

Hi

I suppose you want this, using your example.

In D1 use

Formula:

Please Login or Register  to view this content.

.
In E1 use

Formula:

Please Login or Register  to view this content.

.

Let A1=0, B1=0
In A2 to A385 use

Formula:

Please Login or Register  to view this content.

In B2 to B878 use

Formula:

Please Login or Register  to view this content.

Yes I think this is more or less what I need. A few clarifications thought. The number ranges are slightly differ among the columns. For instance, column A with 380 rows has a range that starts from 5,782 and it ends to 8,624 and column B with 878 cell rows has a range from 5,418 until 8,428. I want column A has the same length as column B, but the range of column A should be evenly divided among the cell rows to match those of column B.

I will try to adapt to see if I can make it my own, but please, provide your adaptation Jose Augusto, just in case.

Thank you very much

See if this is what you want.