Duplicate invoice numbers

Excel Help for Duplicate Invoice Numbers in Automating Data Analysis Tasks

Duplicate Invoice Numbers

Rate this: (2/5 from 2 votes)

	I have a list of invoices some of them duplicates. The reason why they are duplicated is because each invoice may have multiple responsible parties. I am trying to come up with a way to have a list of unique invoice numbers in the first column and have the next column return the responsible parties. Example: Current Needed Invoice Number Responsible Party Invoice Number Responsible Party 10002 traffic 10002 Traffic 10003 Sales 10003 Finance ,Sales, Operation 10005 Operations 10005 Operations, Traffic 10005 Traffic 10003 Finance 10003 Operations Any help would be greatly appreciated
	Posted by esweeney on 02 May 2018

Replies - Displaying 1 to 1 of 1

Order Replies By: Most recent | Chronological | Highest Rated

	Unique List based on criteria Rate this: (2/5 from 2 votes) There is an array formula technique for this outlined at: https://www.spreadsheetsmadeeasy.com/create-a-unique-list-in-excel-based-on-criteria/
	Excel Business Forums Administrator
	Posted by Excel Helper on 03 May 2018

Displaying page 1 of 1