Please give me the VB macro coding for excel:
To calculate average in a particular column for every 100 values in some other column? pls give me the complete coding ....
Like there are two columns namely TT(TEMPEARATURE TIME) and WATER SUPPLY DEMAND.
when TT column increases for every 100 values (ie., 100, 200, 300, 400,.... so on), I need the average of WATERSD to be calculated at that 100th value.. please give me the complete coding.... as soon as possible, I need it very urgently...
More clearly... see in this whenever the TT value is reaching approx. to 100 then the average of water SD has to be calculated at that value… for example, TT approx. reaches 100 at 13th row, now at this row the average of waterSD has to be calculated… then again at 20th row when TT is Approx reaches next 100th value i.e., 200… now at this row the average of water SD has to be calculated… likewise for every 100 increase in TT column, the average of Water SD has to be calculated.( and not at 100th row as in the prev code)..
It would be highly helpful for me, if u can modify the code and give me.. pls do help me …
1. TT WaterSD
2. 0 1
3. 0 1
4. 0 1
5. 13.194 1
6. 20.911 1
7. 32.551 1
8. 37.519 1
9. 40.601 1
10. 55.486 1
11. 69.986 1
12. 84.336 1
13. 99.662 1
14. 114.751 1
15. 129.835 1
16. 144.17 1
17. 159.148 1
18. 172.955 1
19. 187.301 1
20. 201.842 1
21. 217.044 1
22. 231.639 1
23. 246.388 1
24. 261.28 1
25. 275.669 1
26. 290.487 1
27. 303.537 1
28. 316.197 1
29. 328.542 1
30. 340.692 1
31. 352.792 1
32. 366.13 1
33. 380.516 1
34. 395.255 1
35. 408.905 1
36. 421.855 1
37. 433.705 1
38. 447.105 1
39. 459.905 1
40. 473.455 1
41. 487.996 1
42. 502.385 1
ALREADY TRIED CODE IS:
Bookmarks