Sorting and Matching Data in Several Columns

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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,

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
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