Filling in a column based on certain criteria

Richard Buttrey,

Let me start off by thanking you!!!!
Wow, that was great....it worked perfectly...

I just have 3 questions....

First, if I wanted to add a column to everything with the same concept...in other words, in column "C" I had a category labeled 'wind' and it also had an increase rate column added to the increase rate table. Assuming the increment of both wind and mph occur at similar times, how would I add another column to this code?

Also, I've been playing with the code a bit and don't want to bunk it up. But how do I take off the 'mph' part of it?

Finally, what if I had numbers such as 745 instead of 7:45?



I have added another file that sums up these 3 questions into one example.
Please take a look.
I really do appreciate the help, I'm very grateful. Thanks again