PDA

View Full Version : Match same quote number and roll up



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