I have a workbook with 2 sheets calculations and summary .
The summary sheet is a consolidation of column of K as criteria of column C, D,E,F of calculations sheets.
On summary sheet from columns J to O is a summary sheet of same data from column A to F but what differs is the packsize Description of column L .
I have take example itemised no 1 which on autofilter on calculation sheet is listed twice in packing size description but product reference are not same
Looking a formula to extract data in packsize header to read 12*11*70cl all data remain same as per dummy file .HTML Code:
Note it should only take data only if there data in packsize header and sum but if there is not data in packsize header formula should ignore e.g toasted bread , crackers ,biscuits .
Note the data will be scattered in the sheets.
Bookmarks