Thank you for letting me know!

Welcome!! And thank you for letting ME KNOW!!!

Hi,
I saw your problem with weather data. It is really a nice macro you have got from another user. However, sometimes it could be really helpful also to know how to solve these issues the formula way

I have attached an example with formulas. The formula I have used is extremely useful (I use it every week), so I really recommend you to learn it, since in other situations you might fall into, this might just be the solution for you.

In the attached example you get an error message for lines that should be empty. You can delete all these error messages by selecting menu "Edit / Goto". the select "Special". After this click "Formulas" (and only mark "errors"). Klick OK. Now all cells with an error are marked. Press delete to make ALL these cells empty!

I don't attach to many explanations to the formulas. Look and learn! Come back with questions if you like Before applying the formulas, I marked the columns B to G (in sheet "Before"), and named this area "data".

After you have finished, you might like to convert the result of the formulas to values (copy... paste special..as values).

Kind regards
Bjorn

Attached Files

Example_Before_After.xls (40.5 KB, 28 views)

Great formula!!! I tried it in a separate sheet though but it didn't work But it worked perfectly in your example! Actually this formula will help me much more, cause I can control many parameters taken in different intervals!! I will work on it. Excel is full of surprises!!
Thank you Bjorn, it ia a pleasure knowing you

Hi, glad you liked it.
If you need help with the formula in your other sheet, just let me know.

Kind regards
Bjorn