Kal-El
04-03-2017, 11:32 AM
I am looking to do the following
Using Col A (Quote number) as the Unique match criteria
Match all same quote numbers and then on a single line
Display Customer information (which would be the same for each unique Quote number (col B to H
group together all of part numbers associated to the unique quote number in col I to be display with comma separated in a single cell
Sum up all the $$ associated to the unique quote number in col j to be display a single cell
As an example if I had 100 line items and only 5 unique Quote numbers I would expect to see 5 rows with the Customer information and all the parts grouped together and a single sum.
Can this be done?
Thanks in advance
Using Col A (Quote number) as the Unique match criteria
Match all same quote numbers and then on a single line
Display Customer information (which would be the same for each unique Quote number (col B to H
group together all of part numbers associated to the unique quote number in col I to be display with comma separated in a single cell
Sum up all the $$ associated to the unique quote number in col j to be display a single cell
As an example if I had 100 line items and only 5 unique Quote numbers I would expect to see 5 rows with the Customer information and all the parts grouped together and a single sum.
Can this be done?
Thanks in advance