Looping Counter in Exel-VBA
Multi tool use
Desired Output EX I am attempting to code in VBA for the first time and am being challenged with a project. I'm trying to create a looping counter that will search for a value in a column based on two conditions, add one to count and repeat. I need to set up this code to run based on weeks and a value in a separate column. Any input on how to do this and what I may be doing wrong would be greatly appreciated. Thank you.
Edit: I am trying count instances of 5 different ranges in a column of cells and sort them by week it occurred. I have a column in an excel sheet that convert dates to week number. so for instance, if a value is greater than 53.33 and occurred twice on the fifth week of the year, the program would populate a cell with 2.
By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.
