I have a list of invoice numbers in column A, customer names in column B, and part numbers in column C.
I need to combine invoice nummbers to one cell depending on part number for each customer.
<tbody>
</tbody>
So if I am Looking for Shop ABC's invoices for Part X the cell would read "123 456"
Thanks as always!
I need to combine invoice nummbers to one cell depending on part number for each customer.
123 | SHOP ABC | PART X |
456 | SHOP ABC | PART X |
789 | SHOP XYZ | PART X |
987 | SHOP ABC | PART Y |
654 | SHOP ABC | PART W |
321 | SHOP XYZ | PART Y |
<tbody>
</tbody>
So if I am Looking for Shop ABC's invoices for Part X the cell would read "123 456"
Thanks as always!