help with result compare

[Reside]

Hello!

I'm out of ideas and google didn't help me.

How to compare result with tables.

Like i make macro to calculate average amount.

THen now how i can compare average amount with tables and give those names that are over average ?

Please Login or Register  to view this content.

[Reside]

Any 1 have idea or guide how to solve such problem ?

[walruseggman]

I don't know what you mean by "give those names that are over average", so I just highlighted them yellow, but you can do anything with them that you want.

Put this code at the end of Sub Ylesanne1()

Please Login or Register  to view this content.

[Reside]

Hi and thanks.

ment, when first i found out citites average temperature

Please Login or Register  to view this content.

now i would select cities where temperature difference was over average,
and show them under those 2 column( input is city name under tab city, and rain(mm))

Please Login or Register  to view this content.

[Reside]

any more ideas how to sovle that puzzle?