There is a list of numbers given to me in Excel: 0,1,3,5,7,2,4,6,8,10.
A list of such numbers should follow an increasing ordinality. So the numbers following ordinality are: 0,1,3,5,7,8,10 and numbers that do not follow are 2,4,6. Now we have to replace 2,4,6 with equidistant numbers between the 2 numbers that followed ordinality, i.e. 7 and 8. Hence, 2,4,6 become 7.25, 7.5 and 7.75. How do we implement this logic in Excel using formulas, without using VBA?