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 1477 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
5 years 42 weeks ago
6 years 28 weeks ago
6 years 40 weeks ago
6 years 42 weeks ago
6 years 43 weeks ago
6 years 49 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago