I have two groups of data (A and B), each with five columns of measurements: diameter, width, ect.
I want to have excel to match the columns of data group A to data group B only if all of the columns match.
Example:
2 14 3 7 8 = 2 14 3 7 8
So far I've tried using power query, but it seems like I can only match one column to one column.
Any ideas?
Bookmarks