Sorting and Matching Data in Several Columns

Closed
Natha1n - Jan 1, 2010 at 06:12 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 1, 2010 at 08:45 PM
Hello,
I am trying to determine if there is a Excel solution for the following:

There are three sets of data from three differenct sources, each data set contain three columns for each customer account. One column indicates the source of the data (A, B, or C). The second column contains a numeric customer account number and the third contains a dollar amount. Is there some function, macro, or add-on which will sort and match the customer number and the dollar amounts between the three sources while showing the items which did not match and the source it came from?

Thanks,
Related:

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jan 1, 2010 at 08:45 PM
what is meant by "match the customer number and the dollar amounts"
do you mean to say that the customer number of the dollar amounts will be the same

give two or three example
0