Formula Help - Counting Blank Cells and Counting Number of Cells Since the Last Blank Cell

I have a table with 8 items that we sell. Each item has a code, which corresponds to the applicable pricing sale we have for that item, over a span of 8 time periods.

I'm having trouble coming up with efficient formulas that will give me the answers that are in the orange-colored boxes.

pic2.PNG

This table has been simplified -- the true table I need formulas for has hundreds of various codes, and hundreds of periods, so simply doing a 8-step nested "if" statement won't really cut it in this particular project.

I've attached the workbook so you can play around in it. The values in orange are the correct values, and are the cells I need formulas for.

I appreciate any help I can get.

Sure.

To help clarify, Period 1 is the most recent period. Period 8 was 8 periods (weeks/months) ago.

Column B is the current code, which is easy -- Period 1 is the current period, so whatever is in that column is the current code

Column C finds most recent non-zero code that was used, before the current non-zero code. So for example, for the 'Apple' item - The current code is 1, the most recent code that was not "code 1" was "code 2", back in period 4. Therefore, the answer is that "Code 2" was the prior non-zero code. For banana, the most recent non zero code change went from 2 to 1. Therefore, the prior non-zero code was code 2.

Column D finds out when the last code change was. Any time the code changes - e.g. from 2 to 1, from 1 to 0(blank), etc., it's considered a code change. For apple, the last code change was from code 2 to code 1, in period 4. Therefore it has been 4 periods since the last code change. For banana, the last code change was from 1 to blank(0), in period 1, which means it has been 1 period since the code changed.

I realize now that column E was too difficult to explain, so I have revised the table as such:
pic3.PNG

The new column E finds out many periods since there was a code. If there is currently a code, the answer is zero. If there has never been a code, like with Carrot, it counts all the periods.

The new column F finds out how many periods since there was no code (a blank). If there is currently no code (blank), the answer is zero. If there has never been a code, like with Carrot, it counts all the periods.

I've uploaded the revised workbook.

Thanks for the help.