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 588 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
6 years 2 weeks ago
6 years 40 weeks ago
7 years 2 days ago
7 years 3 weeks ago
7 years 4 weeks ago
7 years 9 weeks ago
7 years 17 weeks ago
7 years 18 weeks ago
7 years 18 weeks ago
7 years 18 weeks ago