excel formula
Budget: $30 – $250 USD
I describe with an example. I need 100 rows and one column, that is the basic territory on which the formula works.
I can add any number of data on any row. You need to find out the first and last cells where are numbers, and take in consideration all other cells between the first and last where I enter also numbers, and to complete with data all the remaining empty cells. You need to work only with cells where I didn't enter data. How to calculate? I enter only increasing numbers, so the numbers which I enter between first and last will be in ascending order, and you need to complete all the empty cells between two cells with data. E.g. cell 1 - 10, cell 7 - 55, so the result will be this on cell 1,2,3,4,5,6,7: 10, 18, 25, 33, 40, 48, 55. where the first 10 and last 55 I entered, and the rest is calculated and completed by formula. And so on, if I enter a number 1234 in cell 34, you need to do the same, in this case the first will be 55 and the last 1234 and complete the rest. So on, I can enter any data up to the cell nr. 100, you just need to find out the empty intervals, find out the first and last number on any interval and calculate, complete the empty cells. On the end: the formula you need I need to use on google sheet.
I can add any number of data on any row. You need to find out the first and last cells where are numbers, and take in consideration all other cells between the first and last where I enter also numbers, and to complete with data all the remaining empty cells. You need to work only with cells where I didn't enter data. How to calculate? I enter only increasing numbers, so the numbers which I enter between first and last will be in ascending order, and you need to complete all the empty cells between two cells with data. E.g. cell 1 - 10, cell 7 - 55, so the result will be this on cell 1,2,3,4,5,6,7: 10, 18, 25, 33, 40, 48, 55. where the first 10 and last 55 I entered, and the rest is calculated and completed by formula. And so on, if I enter a number 1234 in cell 34, you need to do the same, in this case the first will be 55 and the last 1234 and complete the rest. So on, I can enter any data up to the cell nr. 100, you just need to find out the empty intervals, find out the first and last number on any interval and calculate, complete the empty cells. On the end: the formula you need I need to use on google sheet.