![]() (i.e., when you run the macro, it looks at every cell on sheet1, processes as above and inserts the relevant value into sheet 2.) Write a macro that more-or-less does the same thing as 1 above, but places values on sheet2 instead of formulae. ![]() (This will only work if the values above and below are non-empty - if your gaps are sparse, that shouldn't be a major problem and you could fix any problems by hand.)Ģ. If the cell is non-empty, it duplicates the value otherwise, it interpolates between the value abova and the value below. That is, the formula on sheet2 looks into the corresponding cell on sheet1. ![]() ![]() ![]() Set up the formulae you refer to on a second sheet that duplicates the first. There might be a value in keeping your original data intact, so that you can still know which values are true observations and which have been interpolated.ġ. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |