Extrapolation over random blank lines

  • Hi all,


    Please can someone offer me some help?
    I have the following spreadsheet (attached), it has a list of times with associated ranges, the time goes up in seconds (every second) the range if whatever is measured, always decreasing.
    Every so often the data received is missed, so I get blank rows.
    What I would like to do is have the code to be able to look at the data and fill in the blanks (the blanks appear at random intervals, there is no pattern, and also could be any number of lines missed), extrapolating the data in the range column, the time is easy really.
    I have highlighted in red the data I have extrapolated, please note the this is a subset, I could have anything from 1000+ rows, so doing it by hand takes time.


    Any help would be appreciated.


    Cheers


    John

  • I got the answer - posted below!


    Thanks to MickG from MrExcel.com

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!