Hi,
I have sample data in A:E and would like to extract results to H:K.
I would like to create a formula that will extract the product names in column H. Lookups will return the values in I:J.
The conditions to return the product names are:
The top 5 products in each Region by Sales that have a positive (including zero) Q1 Change value and an associated negative Q2 Change, or vice-versa, value.
So, in Europe, products AAA, BBB and DDD have switched between negative and non-negative values between Q1 and Q2, and DDD has the highest level of Sales, followed by BBB and then AAA (400 vs 200 vs 100)
Can someone please suggest a formula to do this?
Thanks!
I have sample data in A:E and would like to extract results to H:K.
I would like to create a formula that will extract the product names in column H. Lookups will return the values in I:J.
The conditions to return the product names are:
The top 5 products in each Region by Sales that have a positive (including zero) Q1 Change value and an associated negative Q2 Change, or vice-versa, value.
So, in Europe, products AAA, BBB and DDD have switched between negative and non-negative values between Q1 and Q2, and DDD has the highest level of Sales, followed by BBB and then AAA (400 vs 200 vs 100)
Can someone please suggest a formula to do this?
Thanks!