I have a list of products and their respective price (by month). In the worksheet I have the products in column A and then months across the top and their prices are the data points.
I have already used an array function to count how many of the products fall within various price bands for every month. For example, 10 were less then $100, 20 were between $100-$200, etc...
Now I need to know how to tell which products moved from one price band to another over time. For example, in March 1 product may have been priced at $150 and then in December it is $90. Therefore, it moved down a price band.
I am dealing with a lot of products, therefore any help I can get would be appreciated. Thank You!!!
I have already used an array function to count how many of the products fall within various price bands for every month. For example, 10 were less then $100, 20 were between $100-$200, etc...
Now I need to know how to tell which products moved from one price band to another over time. For example, in March 1 product may have been priced at $150 and then in December it is $90. Therefore, it moved down a price band.
I am dealing with a lot of products, therefore any help I can get would be appreciated. Thank You!!!