Interpolation in Excel/VBA
Is there a way to fill in the blank cells by interpolating between the first non-blank cells above and below?
You can see what I mean exactly in the attached Excel sheet.
| Attachment | Size |
|---|---|
| Workbook1.xlsx | 26.02 KB |
ExcelExperts.comExcel Consultancy, VBA Consultancy, Training and Tips Call:+442081234832 |
|
Excel / VBA ConsultancyFree Training VideosFree SpreadsheetsExcel / VBA JobsNavigationWho's onlineThere are currently 0 users and 3145 guests online.
New Excel Experts
Current Excel / VBA Jobs |
Interpolation in Excel/VBAIs there a way to fill in the blank cells by interpolating between the first non-blank cells above and below? You can see what I mean exactly in the attached Excel sheet.
|
Highest Ranked Users
Recent Blogs
ForumsUser login |
Recent comments
7 years 33 weeks ago
8 years 19 weeks ago
8 years 31 weeks ago
8 years 34 weeks ago
8 years 35 weeks ago
8 years 40 weeks ago
8 years 48 weeks ago
8 years 49 weeks ago
8 years 49 weeks ago
8 years 49 weeks ago