-
Match same quote number and roll up
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules