Single column against multiple rows

%3CLINGO-SUB%20id%3D%22lingo-sub-1668769%22%20slang%3D%22en-US%22%3ESingle%20column%20against%20multiple%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1668769%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20need%20to%20analyze%20the%20pre%20and%20post%20data%20for%20a%20sales%20promotion.%20The%20promotion%20codes%20are%20in%20a%20single%20column%20and%20appear%20against%20each%20product%20represented%20in%20a%20single%20row%20with%20a%20corresponding%20date.%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1668769%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1668789%22%20slang%3D%22en-US%22%3ERe%3A%20Single%20column%20against%20multiple%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1668789%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20can%20use%20PivotTable%20to%20analyze%20the%20data..%20Click%20inside%20the%20data%20and%20select%20Pivot%20table%20under%20the%20Insert%20tab..%3C%2FLINGO-BODY%3E
Occasional Visitor

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!

2 Replies
Hello,

You can use PivotTable to analyze the data.. Click inside the data and select Pivot table under the Insert tab..

@Durrani 

 

= SUBTOTAL( 109,D2:D452)

 

attached the file with the formula.
If you select the date in your table it will total the part of the table shown.
just take a look.
 

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.