vba macro code for counting total days above 32 degrees, 33, 34, and goes on..
VBA MACRO CODE FOR COUNTING TOTAL DAYS ABOVE 32 DEG TEMP, 33, 34, AND GOES ON..
Respected Sir /madam,
I need VBA MACRO CODE for the following:
from B,C columns i need totally how many days temp is 32 degrees and above, 33 degrees and above, 34 degrees and above, goes on.. i have did manually for your easy understanding. that is , from C column, in the given excel sheet it is 1922 days,out of 1922 days, 306 days has got 32 deg temp, 349 days has got 33 deg temp, goes on..
important note: in C column we have decimal values also like 32. 5, 32.4, 32.7, 33.5, 33.9, 33.4, etc., which all must come under 32 and 33 category in the required output respectively. VALUES LESS THAN 32 AND ALL NO NEED.
hope i m clear and not confusing... please find the attached excel sheet for your kind reference...
please do help me... I need very urgently...please...