Sorting and Matching Data in Several Columns

Closed
Natha1n - Jan 1, 2010 at 06:12 PM
venkat1926
Posts
1864
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,

1 reply

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