Cells containing 8888 figure, assign each cell an average of final value

Hi all,

I have a huge rainfall data which I need to convert to before I can use it for the intended purpose. Basically, there are measured actual rainfall data as well as interpolated values within the data represented by the number ‘8888’. After the end of the interpolated cycle, there is a value which is the total of the preceding interpolated values.

What I need to do is obtain average numbers for the interpolated values.

The data looks something like this:

8/01/1998 7:54 AM 8888
8/01/1998 8:00 AM 8888
8/01/1998 8:06 AM 8888
8/01/1998 8:12 AM 8888
8/01/1998 8:18 AM 8888
8/01/1998 8:24 AM 8888
8/01/1998 8:30 AM 8888
8/01/1998 8:36 AM 8888
8/01/1998 8:42 AM 8888
8/01/1998 8:48 AM 4

I need to find a way to convert the 8888 values to an average of the final total value; in this case, 4. So for the above example, I will need to get a return of 0.4 in place of the 8888 values; i.e. 4 divided by10cells (cells with 8888 in them inclusive of the final total value of 4). Do keep in mind that the rainfall data which I have is huge!

I've got no experience with VBA, so if there's an Excel method to go about doing this, that would be great! If not, then I guess I've got no choice but to to learn VBA and apply it accordingly.

Many thanks in advance... !!

It helps if you can post a dummy file.

Not exactly sure what you mean by a dummy file, but I've attached an example of the type of file which my data looks like. What I would like to do is described in the earlier post. Hope this clears things up a bit.

Cheers! :o)

hi there, anyone with any ideas on the above problem?