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 421 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 34 weeks ago
6 years 20 weeks ago
6 years 32 weeks ago
6 years 35 weeks ago
6 years 36 weeks ago
6 years 42 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago