So this is my problem. I have a "Sales Price" column in my worksheet. My task is to count the number of sales prices that fall between three categories(Less than 500k, between 500K and 1M, and finally greater than or equal to 1M). Initially I was using the COUNTIF function but I'm trying to get a macro for this because I have to do this stuff over and over!
The other thing that should be taken into consideration is that since I'm getting this data from some database, my rows are constantly changing. Therefore whatever macros I get should incorporate the fact that my rows are changing
The other thing that should be taken into consideration is that since I'm getting this data from some database, my rows are constantly changing. Therefore whatever macros I get should incorporate the fact that my rows are changing
