Sep 15 2020 07:22 AM - edited Sep 15 2020 07:47 AM
Hi, I need to analyze the pre and post data for a sales promotion. The promotion codes are in a single column and appear against each product represented in a single row with a corresponding date. As I select a promo code it only gives the promo period but not the pre and post period. Please refer to attached file for understanding.
Thank you!
Sep 15 2020 07:25 AM
Sep 15 2020 08:41 AM
= SUBTOTAL( 109,D2:D452)
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.