Home > Forum Home > Automating Data Analysis Tasks > duplicate invoice numbers Share

Duplicate invoice numbers

Excel Help for Duplicate Invoice Numbers in Automating Data Analysis Tasks


Forum TopicPost Reply Login

Duplicate Invoice Numbers

Rate this:
(2/5 from 2 votes)
ConfusedI 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 on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most Recent | Chronological | Highest Rated
Happy
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 on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for duplicate invoice numbers in the