I have in cells B1 to B90 the word " distance" in different rows at random ,
other rows have numbers in them. What I need is the word "distance" to have a
number before it , in column A . Every time the word "distance" comes up it
needs to be added to the last "distance" word, like : distance=1,
distance+distance=2, distance+distance+distance=3 and so on.
eg:- A1 1 B1 distance
A2 (blank) B2 22.7
A3 (blank) B3 33.8
A4 2 B4 distance
-- A5 (blank) B5 23
A6 (blank) B6 5.8
A7 (blank) B7 6
A8 (blank) B8 17
A9 3 B9 distance
A10 (blank) B10 34.9
Down to 300 rows

Hope some can help
thanks
bill gras